The Apollo is, frankly, a better looking ship. It looks smaller, older, frailer, and generally better shot up. The Herc 2 is so freaking smooth, random particle trails don't do the job.
Not to mention the fact that the Apollo gives it extra 'WHOA!!!' factor, since everyone here, and in my case all my friends, have seen the FS1 intro (I stuffed it down their throats). So you see the imagery from the FS1 intro, and the view starts panning away from where Ash (or whoever) died, and then 'ZOMG' in swoops what is, metaphorically, SCP/FSO/MVPs. In a way, you're showing all the old stuff, that we all recognize for Freespace, an old game, that's dead. The bit from the FS1 intro ends, and then in comes FSO to the rescue, resulting in a massive battle that shows off everything the game has to offer.