Honestly, Picard asked a very relevant question to the modern age. What if our societal standards aren't what we thought they were, and we've just had rose-tinted glasses convincing ourselves otherwise. Of course, we never saw them actually deal with that properly, but S1 was a much more interesting series than S2 and S3 were.
The writers flat out rejected Roddenberry's vision of a better future and here's a take on why. We've reached a point in culture of deep pessimism about humanity, and so the characters in Picard are just as dysfunctional as we are.
Another reason is that actual utopias make for pretty boring writing. Humanity convinced itself that they lived in a perfect world, but most of the writing was about the cracks in that facade. Even the preachy and awful first season of TNG had the character of Q demonstrating that we still had a long way to go.
Same here, then I watch _The Orville_ and I'm happy again.