Realistically, this is the best anyone could have hoped for. It works because it's heavy on the Member Berries, and Member Berries is better than whatever the fuck the first two seasons were. The original characters aren't treated like retards. While some of them have evolved or had personal growth, they generally act how one would expect them to act, (except Geordi for some weird reason).
Its basically a TNG movie as a series right now. I'm watching it because people have said its good (which is a fucking low bar) and its just....ugh. I'm pretending the Picard bot shit didn't happen because who the fuck would go, "Sure, turn me into a robot, but keep me as a 90 year old man with all the same health problems".
Also, I get that actors age and shit, but in a future where you can cure radiation sickness you can't cure aging? Really? Riker is honestly the best part of the show so far, since it looks like Jonathan Frakes is loving being back in Riker's shoes. He really makes me feel nostalgic, even if the first couple of episodes are basically 'Wrath of Khan' (Nebula, Outgunned, etc.).
The largest problem to post-TNG era, unlike post-TOS era, is that Patrick Stewart fucking hates Picard. HATES. It doesn't matter that its made him wealthy, beloved or iconic. He does not like the character, does not like the genre. Its a big reason why a lot of post-TNG movies are shit. Nemesis was clearly going to be a part one of two and copy 'The Search for Spock' with Data, but it preformed poorly and Stewart didn't care enough about the character and was happy to be done with it.
The problem with adaptions nowadays or 'sequels' or 'soft reboots' (Picard is a TNG reboot in a new universe, because JFC it is trash) is that its like "WE HAVE GOT TO DO OUR OWN THING" and then when they do it, lose the old audience completely, don't attract a new audience, and their new canon has burned the franchise to the ground, they panic and run right back to the source just to copy and paste it. "SEE WE LOVE IT TOO." It goes far beyond homage, because the entire plot structure is just copied. See 'Star Wars'.
Because they miss the essence of what the problem was in the first place: You cannot stray far from the tone or message of the original, or it is no longer a part of the thing you are trying to continue. It may as well be something new. The only reason it works is because the old stuff is so good that a little bit rubs off on the new product. Its incidental.