6.5, maybe. I enjoyed watching it. But there was a lot that didn't gel and overall it didn't live up to my expectations.
The good - great to see Picard, Dahj was awesome, Seven/Annika was great. I liked Jurati (mostly) and Rios and his holos eventually grew on me. The peak of the show was Picard finally meeting Soji and the running around on the Borg cube. I liked seeing Hugh again, more of him would have been good.
Less good
- Soji was not as engaging as Dahj, got really bored with her 'romance' with Spy McSpy
- Rafi didn't work for me, seen that scene with her son a million times on other shows, and Elnor never got anything to do
- ending was weak - both the beacon thing and the fake death scene
- didn't really need to see Riker and Troi again (but at least this was no TATV)
In particular they could have done a better job of pulling things together. I assumed throughout much of the show that the big threat the Romulans were worried about was that somehow the Synths would reactivate the Borg cube. Nope. There's this new completely new thing, and the Borg cube has crashed and doesn't matter.
Why hundreds of ships? It made having Riker in command, rather than an admiral, nonsensical. But if the Romulan cult could only gather a few ships, and Starfleet had to scramble a few ships on short notice and activate reservists to get some of them out of mothballs... it would almost have made sense. Also, makes it clear that the cult is/controls the Romulan government. If it was just a few ships it could be a hidden faction that has infiltrated its own government just as it did Starfleet, which is what they seemed to be going for earlier in the season.
Did Jurati kill because of an implanted command from Oh, or just because of the scary vision? Not specifically addressed - even a "she'll never know" would have reassured me that the show was dealing with that possibility, which was implied by her having been made unable to talk about it.
The Romulan refugee thing outside their own borders doesn't really make sense, given the continued existence of a powerful Romulan empire and the premium on transportation (especially after the Romulans destroyed the rescue fleet). Seems like they had ideas around Romulans scattered across the quadrant as refugees and ideas around the Romulan Star Empire as a powerful antagonist and decided to go with both... they really needed to pick one.
I hope Season 2 will address what happens when Romulans learn who it was who attacked Mars.