I'd consider Discovery to be optimistic as well - striving to make the world(s) a better place in the face of conflict, uncertainty, and disaster is still optimism. In fact, it's arguably the type of optimism we need now more than ever before.
The first season of Picard flirted with similar themes, but I don't think that series ultimately went anywhere with them.
I think the current approach is the correct one, even if it produces a few misses here and there.
A variety of tonally distinct projects, aimed at different demographics, telling stories.