That's like asking which would win, a Ticonderoga class cruiser or a Nimitz class carrier. Gee, I wonder.
Well, considering that a Nimitz
's only hope of defense against the likes of Ticonderoga
is having another Ticonderoga
ride shotgun for her - whereas a Ticonderoga
is specifically designed to stop what a Nimitz
can throw at her...
Frankly, it would be nice to know what Starfleet intended the Galaxy
and the Intrepid
to do, respectively. But both seem to be jacks-of-all-trades. Except that the bigger ship may actually be an ace-of-all-trades instead...
Galaxy class wins in virtually everything except speed, agility and computer power.
Dunno about the latter point. While assorted giga- and teraquads are thrown about in dialogue, there's never an estimate on the total computing power of either ship. And one would suppose that a bigger computer would have more power, and a bigger ship would hold a bigger computer.