It's a fun time travel/alternate reality adventure that really shows off the strengths of its cast old and new alike. Recasted roles like young Guinan and Confederation Timeline Borg Queen also shine so bright.
And it ends on a hopeful note. Picard learns to be vulnerable to love properly. Even though Rios left he got the home and family he always wanted, Jurati similarly found belonging in bringing together a new Borg Collective. Seven and Raffi are in a stable place in their relationship and both have a happy future on the horizon and Elnor is alive and well and ready to thrive in Starfleet.
I can understand the detraction that it is just a long Tapestry/TVH but it is so much more than that and had the potential to be so much more impactful moving forward until season 3 pissed over the whole franchise.