That is the series' greatest sin. You get glimpses here and there, but no, you never get that hopeful vision of the "perfect" society that Roddenberry envisioned. I say "perfect" because, as we know, even Kirk had his prejudices.
If you get to the fourth season, if I'm not mistaken, there's a...