I have no idea why people don't find Picard optimistic in its own way. But then again, when you come in expecting to hate something of course you're going to hate it. I know that lesson all too well. People say Raffi taking drugs isn't Star Trek, but the crew accepting her despite it *is*. Star Trek Picard stars a host of broken or beaten down people who have an opportunity to rise up. I don't see how it gets more optimistic than that.
Furthermore, as someone wrote in a reddit post today, most struggle with the differences in format between classic Trek and Picard. Classic Trek is episodic; Picard is long form serialization. Here is the relevant quote:
if Best of Both Worlds part 1 was the first episode of the season, and it stretched out for 14 more of Picard as Locutus tearing through the beta quadrant towards earth, while Riker and Shelby bicker the whole time about the best solution. what if Past tense was 10 episodes of Sisko and Bashir stuck in the sanctuary zone having to fight for scraps, while the complacency of the upper class is laid bare in Dax's story, and Kira and O'Brien become increasingly desperate to locate them while running low on resources and dealing with whatever dominant power exists in that timeline. consider Yesterday's Enterprise, The Drumhead, Hard Time, or For the Uniform stretched out with active consequences and repercussions as opposed to just being one and done. Voyager was going to have Year of Hell be an entire season, but then tptb decided it would be better as two episodes that ended with a reset button.
A massive flaw with old Trek is that serious things happen and it's never followed up upon. If Star Trek TNG were made today and the MAIN CHARACTER becomes a bad guy do you honestly think the show wouldn't go in a dark place after the fact? In TNG after Lotocus, you've got the episode Family, where Picard goes to his home to heal from his experiences, and then his experiences as a mass murderer (although programmed by the Borg) are conveniently swept under the rug the rest of the franchise, a few mentions (DS9 ep1 and First Contact notwithstanding).

Flaw.
Remember when Picard ends up living an entire life time on an alien planet, has a wife, kids, and entire community and they die out? And he just kind of like, doesn't even have to go Troi for therapy for it?
Flaw.
Voyager regularly made reset button episodes so that nothing of consequence ever sticks. Remember the time when the original canon Kim DIES in an episode and a Kim from a literal alternate dimension replaces him and it's not mentioned again?
Flaw.
Old Star Trek is flawed as fuck, Deep Space Nine being the lone, sole exception (which I must remind you that at time of air date was considered "not Trek?" and is the darkest in the series) because nothing of repercussion ever fucking happens. All Picard does is rather than ignore these things happening and going to another fucking unrelated episode, it continues it.
Big whoop.
You have defended him by saying this show is worth a damn, or that the writing is good. Which honestly is pretty laughable.
No your argument is laughable. I have not, in any way at any time inferred that I view Picard as perfect you simpering troglodytic chuckle fuck. I liked Picard and thought it had a lot of good moments. Was it perfect? No. Could it be roundly improved? Yes. That still doesn't take away that I really enjoyed the Riker episode, or the slower pacing. Chuckle fucks like you have no ability to think for yourself. You're a robot constantly bitching like a complete and utter fa.ggot. Saying the show that takes three or four episodes just for the cast to get to
outer space, is too break neck and too pew pew.