I wouldn't say that at all. Both the first seasons of Disco and Picard start off with rather bleak outlooks of things, in reflection of their lead character's outlook on the world, Michael facing a life sentence in prison while the Federation is engulfed in a war, Picard wary and cynical as he winds the days by in retirement disillusioned with the Federation and Starfleet and what they've become. But by the end of the seasons they each have their faiths restored and the seasons end on a thematic high note. Disco managed to maintain a sense of optimism throughout its second season, and certainly Lower Decks offers an optimistic outlook as well.
Yep. Go back to the 1960s, and that's what Star Trek is about. "We're human beings with the blood of a million savage years on our hands, but we can stop it. We can admit that we're killers, but we're not going to kill today. That's all it takes. Knowing that we won't kill today." Star Trek wasn't utopian in the sense of portraying a perfect future. It was about a better future, but one whose people still had work to do.
What the new shows don't have is the in-your-face utopian paradise that so defined TNG, and that's fine. You don't really need that in order to be optimistic.
TNG is an outlier. Its presentation of a perfect world does not align well with the rest of Star Trek, in which a perfect world is the goal and not the setting, and I wish fans would stop using it as the platonic ideal of everything Star Trek.