Again; Are your armament statistics based on pre or post Dominion War refit?
Stats off MA. The
Galaxys we see in the Dominion War would had two extra arrays on the nacelles, so the pre-DW would be 12 arrays/2 launchers and the DW would be 14 arrays/2 launchers.
Even with its shield negated the E-D should should still have kicked the BoP.
That's one of many reasons why Generations is a horrible movie. And basing your assumptions on events depicted in it is the essence of grasping at straws.
You might not like the movie but it happened and its canon.
You had a go at another user for not basing his comment on available information yet you'll just dismiss it if it doesn't gel with your ideas. That's not very fair.
Enough with the nonsensical "number of phaser arrays" argument. That's for newbies. Phasers don't work that way. Otherwise, we could divide the big phaser array on the Galaxy saucer into 100 parts and then -GASP!!- Galaxy will have 110 phaser arrays!!! Lets do the same to the one on the bottom, and it will have 210 arrays!!
Phasers are dependant on the power source, type, and length. Yeah Sovereign might have newer type XII, but the type X on the Galaxy is 2.5 times longer, and that's just the main one. We don't know what power this amounts to and who it gives an advantage to, but they're probably close. And the power generation is probably the same.
Sovereign might have more launchers, but they're nowhere near the same capability as the two massive ones on the Galaxy. We see those fire about 7 torpedos in a second on the Husnock ship, we don't see Sovereign unleash that kind of firepower. But Quantums might make up for the slower firing rate.
Same with shields, Sovereign might have advanced regenerative shields and smaller area to cover, but Galaxy might have more generators overrall, which again puts them in the same ball park.
In the initial run, I'd give Sovereign the edge because of advanced technology which puts it on par or slightly ahead with weapons on the Galaxy, but that's not a fair assessment, since initial Galaxies dont' exist anymore.
Sovereign is not a replacement for Galaxy, it's clearly stated in Insurrection when Picard says "Does anyone remember when we used to be explorers?" Galaxy is still going strong, and sometimes it gets unfairly blasted by people who play too many games. Her original specs:
To provide long term platform for:
-exploratory
-military
-scientific and
-diplomatic
missions. Not jack of all trades, but ace of all trades. As such, she supposed to be fitted with the best of everything in those areas, minor upgrades every 5 years, major every 20. Starfleet is not going to invest massive resources into Galaxies, and then let them be destroyed by any Joe Schmo they come across.
In the end, I can see both ships being about the same, like I stated above, with Galaxy being better at scientific pursuits due to extra labs etc, while Sovereign is more maneuverable, may be faster, more rugged and flexible, etc, - more strategic advantages.
As for the battle in Generations, that's down to Riker not the ship, just like it was down to him in Insurrection, why didn't Sovereign just turn around and paste those Son'a with quantums and photons? Riker likes doing things in unorthodox fashion.