Oh a good character- or even actor coughmichaesheencough can absolutely elevate. And like you said, damn, that proper sendoff Nemesis denied us.
The main issue i have is it’s got the common problem witha lot of Kurtzmann treks (and into darkness) - cherry picking the high notes from the franchise, then misusing them.
Reusing trek threads can be amazing - what voyager did with Borg lore, hell, what WoK did with space seed! but there needs to be actual solid progression and daaamn did it fail. The fallout of the dominion war is something i would love to see handled properly, especially the implications of the fall from ideals under duress DS9 ran with. But Picard didn’t deliver. And as awesomely horrific as that Giger queen was, it was all sizzle very little steak.