Spidey, I'm afriad I'll have to steal your talent
To do that, I'm guessing how you did it.
I think you FREDded it to make up the visuals, and perhaps used moviemaker (or a similar program) to add the sounds? That'll serve as a good strategy to make those kinds of cutscenes, right?
I tried making a cutscene with sounds like that, but I think it would be really hard trying to time the "play sound from file" SEXPs perfectly, so I think moviemaker will be an easier way to settle it.
EDIT: I do think it's an already classic intro cutscene, especially because it looks exactly like the ships ingame. Whether you add the zods or not, add an Orion or not, it still is a perfectly made video.
Although on the extreme, perhaps this isn't particularly aimed to be for advertisment purposes. I mean, think that you're a newbie; you see a super-awesome spacebattle;
"wow, look! There's a frantic pilot trying to make it to a huge space station! Oh no! Some alien mothership comes out of a big hole! Oh good, the humans are here, and they fight them off...well, they don't exactly win, but it's an awesome battle indeed!"
Maybe, yes, because of its awesome effects and all, people who don't know the game will be entertained and, perhaps even willing to get the game itself, but ultimately they will need to read the actual story. I mean, as someone who's ignorant of the FreeSpace saga and its dramatic FSO megamod, you'll probably see it as "yeah, a really nice-looking spacebattle, just like in Star Wars movies...", so it might well rank alongside space battles in movies themselves (e.g. Battle of Endor to an extent), but the people who'll really be amazed at this are the older guys, those who've played FS through and through, those who've downloaded the latest MEDIAVPS, since it, undoubtedly, looks more awesome than awesome, it's classic, dramatic and all. It's perfect!!! - for a FreeSpace ingame battle.