I haven't read the thread before posting this, so I don't know if I'm just not enough of a TNG fan to love this ending - and now having seen the season in totality, yeah, it really didn't hold up.
IMO - In the end, Terry Matalas didn't stick the landing for me. It was INCREDEBLY nostalgic, and that was okay; but sorry, the idea that the original Borg have been dead/dying since the end of
Star Trek: First Contact; and the Borg Queen took 30+ years to get her hands on Jack; and effectively just played with Jean-Luc Picard like a mouse and didn't just take them ALL out when they became a threat...
And yeah, exactly what were the Changelings getting out of all this that made it worth it to them. Yeah Vadic might have wanted revenge, but you'd think the lot of them would want something more. Hell, I still have no clue why she (Vadic) supposedly hated Picard so much.
And don't get me started on reviving/rebooting
Q <--- That was just ridiculous. Plus if you going to go that crazy and undo the best scene from Picard S2, you'd think Mr. Matalas could have done another Wesley/Traveler cameo - maybe offering Jack a spot with the Travelers?
^^^
IMO no worse then rebooting
Q.

(And I'm sure John De Lanicie was just rolling his eyes when they had him on the call sheet for S3 after he did that nice death/goodbye in S2.)
Yeah, Terry Matalas really JUMPED THE SHARK for this ending.
I like PICARD S3 more than S2 - but yeah...as to the ending, as I think and write more about it, sorry, it wasn't good; it just wasn't. <--- And that's annoying because there was a lot of PICARD S3 I liked; but yeah, to hit a home run, you NEED to 'stick the landing' - and they honestly didn't, yet again.
As for 70f9/Raffi/Jack as a 'Legacy' continuation <--- No thanks. I do think Jeri Ryan is a good actress, and overall they gave her better stuff to play/do in PICARD S1-S3 then they ever gave her on Star Trek: Voyager (but to be fair, to this day I consider it the worst Star Trek franchise series, and really didn't watch more than a handful of it's episodes past
The 37's. I did give the S4 VOY two parter
Scorpion a view; but as soon as they had 7of9 in that Silver catsuit...yeah, didn't bother continuing.)...
But my point: She (Jeri Ryan)still doesn't have the draw/star power to be a Lead for a series of this type; not when there is so much other Star Trek in the works with larger stars (actors). Who knows, maybe one day they'll try a 'Legacy' streaming Star Trek film with the cast they set up; but if I were Terry Matalas, I wouldn't be expecting another call anytime soon.
It was a decent coda to TNG - but overall, yeah, this ending could have stood another writing pass.
But hey, Terry Matalas looks like he got everything he personally wanted from this, so congratulations to him on that as it doesn't happen often in Hollywood.
I still liked this season a lot more than PICARD S1 or S2 (S1 really blew the ending and taking 3 episodes before really starting its main story...

And S2 for me was just a misfire on many cylinders. 'Not Guinan' never really worked for me. If you couldn't get/afford Woopi Goldgerg for the whole part of the story you needed her charcter for - REWRITE!)
And to this day, I think the best 'new' character (and especially his intro) was
Elnor. but said character was underused in S1 - Sloppily used in S2 (and yeah, if they could work a Romulan in as a Gary 7/TOS S2
Assignment Earth type 'Supervisor' (of course we know now it's not an alien race doing this but rather a godlike Wesley Crusher); they could have worked Elnor in more than just using him as some 2 minute 'combat hologram'. And yeah, guess Terry Matalas even killed him off if her was still on the USS Excelsior when the Borg blew it up <--- WTG Terry Matalas; hell Raffi and 70f9 never mention him AT ALL in PICARD S3.
So yeah, I guess what I'm saying is PICARD the series was okay IF you don't think about the actual stories it told too much...