I enjoyed the finale. Wasn't perfect, but it landed the beats it needed to really well.
The scenes with Picard and Data were extraordinary, and perfect character moments for them. I'm glad that Data finally got a proper sendoff instead of just being 'sploded real good at the end of Nemesis.
The resolution to the giant conflict not involving violence or a giant space battle was the perfect way to end it. Picard did his Picard thing to once again save the galaxy, and finished his character arc of redemption and being useful quite well. Not sure about him being a sack of meat android, but it was a very Trek story beat.
Seeing Riker in a Starfleet uniform again talking mad shit to Oh was great, and I hope we'll get to see more of him again in the future. Frakes has still got it.
As for what I didn't like, the Romulan and Starfleet ships all looked the same. I'm guessing it was a time and budget thing, but from TNG onward, any fleet of ships has always had a wide variety of classes and sizes. Going the copy and paste route was really jarring. Not a fan of the industrial designs they used either.
Raffi and Seven holding hands was just...weird. I mean, if they're bi and into each other that's totally fine, but it just came out of nowhere. Planting the seeds for any kind of a relationship in a story is better served by giving it some build up and attention, not just a random "WTF" at the end of an episode.
Narek was completely forgotten about in the second half of the finale. Just poof, gone. No mention about him from other characters. I expected at least a blurb or two about him from the other characters wondering where the fuck he went.
Anyways, I'm really excited for season two. Now that the characters are established, they can focus more on the stories and less about exposition and character introduction.
I highly recommend checking out Michael Chabon's Instragram. He answers a lot of fan questions and fills in a lot of plot gaps.
https://www.instagram.com/michael.chabon/?hl=en