I agree this is important to keep in mind. I wonder about this a lot when I find myself admiring fictional characters for how they handled situations and how it turns out for them.

I don't think TNG is as simple as you make it out to be. All of the characters have serious flaws. Picard does make mistakes (including some very serious, consequential ones). Characters do get angry, jealous, etc. and do bad things. Sometimes their friends help them overcome it, other times they figure it out on their own, etc. It's episodic so it usually goes back to the status quo, and that can feel kind of trite through today's lens. But it's exactly that ability to solve problems (technical, emotional, organizational, etc.) as a team that's so compelling for many of us.