How this ends IMO. Not sure how they liberate the fleet, but the rest...
- Worf dies saving his friends. His last words are "Jadzia" as he goes out in a blaze of glory. He has the brave and honorable death he always wanted, and fulfills a destiny different than Kor, who outlives everyone. There is no Kor mention (too deep a cut), but it is his character arc. He dies well.
- They're gonna do a riff on Star Trek Destiny. Picard and Beverly will confront jack in person on the cube, and he will destroy this Queen, and change the Borg as a concept. Not exactly the Destiny way with the Catatoms, but into something positive (Jurati, but better).
- Jack resolves to take the Cube into the Delta Quadrant to liberate the rest of the Borg collective since he's a "transmitter" and will transmit their liberation.
- Beverly goes with him, since she doesn't want to lose him like she lost Wesley (heavy foreshadowing on this). She'll never return to the Alpha Quadrant.
- Data goes to Copelius (maybe with Geordi) since he's not longer alone in the universe. We get a brief Soji cameo and maybe a look at Lal's portrait, as he resolves to bring her back now too. Full circle with Season 1 Episode 1.
- Geordi saves his girls and decides to help rebuild starfleet rather than curate a museum.
- Deanna rejoins Starfleet alongside Riker. Riker becomes Captain of the USS Enterprise G, which is in fact, the upgraded Enterprise D in a modified Galaxy-X configuration (per Matalas' tease we'll see "-X" in the finale). Also draws one of the last aspects of All Good Things into canon.
- Picard goes and meets Laris and moves on with his life, his adventures being over at last.
The crew is broken up.
-Seven of Nine reconciles with Raffi, and becomes Captain of the Titan. Janeway and/or Tuvok cameo to wish her off. She realizes she carries the legacy of her three mentors - Janeway, Picard and Shaw - who were all great and very different captains. She, the Borg who became human who became a Starfleet Captain, is their Legacy.
And that is how the series, and the TNG era ends.
next up: the Legacy Era.