It's not too bad. Kinda good even.
I picked up where I left off. Episode 6.
First, it's interesting that this show has a few Romulan characters who are fantasy characters transported to the Star Trek universe. We have Romuland Legolas, and we also have Romulan Jamie and Cersei Lannister. I find Romulan Jaimie interesting, and I noticed that in the end he did care for Soji, despite carrying out Romulan Cersei's orders.
Second, it was a little goofy when Soji kept scanning herself and going "noooo" as she discovered she was an android (she only did the "noooo" once, but still).
Third, I find Raffi to be comically over the top in the way her alcoholism is depicted. She's constantly carrying around a bottle of liquor and taking a swig practically everywhere she goes. She can't keep that stuff in her room and get back to it after finishing with whatever she needs to do on the bridge? I know she and Picard go way back, but even so....
Fourth, the best part of this episode by far was Jean Luc being haunted by his past with the Borg. I think I see what you meant when you said that he has his flaws, such as when he declares that the Borg "cannot change". We also see in the episode that when he sees evidence to the contrary, he immediately changes his mind. Many people would not do that; I think that's very admirable for an admiral.
Fifth, if this style is too irreverent, I apologize. I listen to a podcast where the hosts take this approach even towards the things they like. I liked the episode overall; there were simply things I found goofy.