Nostalgia. Flawed Picard. Damaged characters. A story arc rather than an episode that happens and is never mentioned again. And probably because I haven't thought about it too deeply, I've just been watching it for entertainment.
I never really cared much for the Roddenberry ideals - I mean, it's great that he was optimistic and wanted to set a flag for what humans should aspire to be - but I never found his rules about no conflict between the characters, or statements about how humans have 'evolved' to be that realistic, so it doesn't bother me that Picard has gone against those rules.
I think the changes to Picard are realistic and true to the character. The end of a career can feel like a failure, especially when it ends with a failure, and he's had twenty years of mulling over regret.
The other points sound like nitpicking - the Romulan sister (nah, I can't remember her name) released all the Borg into space because otherwise they would attack her and all the other Romulans. With the Romulan homeworld destroyed, the warbirds were all probably off-world - there was an evacuation and the warbirds would have been part of that. The Romulans have a Borg cube because it was in Romulan space and they captured it. Soji's a post-grad student/research fellow, so she's not so young that her twin sister can't have a research job of her own.
But for you, things I don't like. The F-bombs do feel gratuitous. "Ooh, we can swear in Star Trek now". And while I do like the take on older Picard, some things don't feel that realistic. Like, he doesn't talk with his former first officer for fifteen years? There are some really disturbing scenes (the ones involving suicide)
The big main plot is hard to follow - but I think you have it the wrong way around? The super duper synth life from millions of years ago nearly wiped out the organic life forms, and the surviving organic life forms left it as a message to their future generations. (I haven't seen last week's episode though?). Anyway, I'll reserving judgment until the end of the series.
Also, thinking about it, we just had a season of Discovery where Starfleet clandestinely decided to destroy anything that would lead to the development of artificial intelligence, and this season is all about research into AI and creating intelligent life forms?