My memory is hazy -- I'm not nearly as involved with the journalistic side of gaming as I used to be, nor do I have time to follow this stuff closely anymore now that I'm in my mid-30s -- but I remember that "Fury" was this crazy last-resort superweapon that the Vulcans used to end their ancient war with the Romulans by basically eradicating most of their fleet, and the over-arching story was that the Romulans had decided to settle the score by finding Fury and using it to extract revenge against the Vulcans. It had an episodic nature, similar to the old 2D Interplay games, but each episode focused on a different character. I'm sure TrekCore or Memory Alpha or some other data repository has more information.
The more I see of this DC Fontana-created masterpiece that never was, the more utterly heartbreaking it is .... Can't somebody get a Kickstarter going to buy SOVF from whoever owns it, then fully flesh the game out & put it on sale?