I own several other exploration ships, what makes the Corsair stand out? In other words, is its only trick the big guns?

The Corsair offers the same functionality as a variety of other exploration ships but is catered towards a more offensive style of gameplay. It also has a different set of roles for a crew of four compared to, say, the Constellation.