God thank you. A perfect example of this was Picard season 2.

What they did was go back to the bad timeline and showed everything we're doing wrong and shoved our noses into. I remember them looking at the forest fires and the tear coming down and she said it's already starting. Fucking thanks. I already feel like shit about the state of our planet, thanks for making me feel worse about the future instead of optimistic.

They tackled climate change in TNG elegantly. The realized warp technology was destroying an area of space. Geordi was against it because he didn't want to admit his life's dedication might actually be hurting space and others. They all worked together to come up with a temporary solution with goals to fix it long term. That was the optimistic future show I wanted to watch, showing that humans couldn't past the differences of today to solve real problems.

It's why TNG gets regular rewatches while I've never watched Picard again. If I want doomsday shit I'll watch literally all the other shows ever made. I watch star trek because I'm feeling sad and want a shred of hope.