The Soong son thing is a bit mixed for me. I love Spiner, and I thought he brought a lot of natural charm and charisma to that role. Played it great. My problem is simply his very existence. It either completely rewrites Star Trek lore with regard to Data, or assumes a lot of pretty dumb stuff, like that Soong had a son that he never once mentioned, which I feel is odd given all of the Soong episodes prior which either stated or heavily implied that Data and Lore were his only real children. So either Data was completely unaware of Soong son, or he wasn't and no one ever mentioned it ever. If it's the former, then why in god's name do they have a Spot 2? It just felt like a cheap way to get more nostalgia in there and make people connect with what they remember, but it makes no logical sense to me, imo.
I agree with the rest of what you wrote. The characters just seem very poorly thought out. I have no idea what is going on with Agnes, and none if it is very consistent. Rafi.......again, similar. She's got a good actress, but is just so all over the place that I can't tell you very much about her at all. The Romulan Ninja is still an awful character, even if I am warming up to the actor playing him. He is just so one dimensional. Still digging Juan Solo, but he's testing my patience with the inconsistent character writing as well. Many of the characters, even Picard, are played with such charm and charisma, but are written almost entirely as plot devices and a collection of random and unconnected moments. The moments, on their own, such as the "i love you" scene between Rafi and Picard was lovely, but didn't make a lot of sense in context with everything else, at least without more backstory between them.
The whole robot planet started off very Star Trek but just became a joke when they went full Bender with their "kill all humans" thing. Bringing in Picard's Romulan failure? Soong joining them? Eh. It just felt like they knew point B but didn't care how they got there, so they just jumped to it. It just feels like so much of the story is a bullet point of things they want to do with almost no connecting tissue, and no real investment in any of the characters beyond making sure they hit those bullet points.
Anyone else think the robot god species are the ones that V-ger found? They do love to connect random memorable things from previous Trek, so it wouldn't shock me if it's a v-ger connection.
I have no idea what they're going to do with the robot god race. I find it quite silly, shocking, I know, but maybe it'll be interesting. Not excited for a huge space battle, but we'll see.