TNG does fail the progressive test. There’s basically one person of color on the regular cast, if you don’t count Worf since he’s an alien. I love Patrick Stewart, but Yephet Kotto should have been captain. Or Riker shouldn’t have been a bland Steven Collins clone. Or even cast an actual Hispanic as “Macha Hernandez”.
Gay issues were avoided. Gene kept promising but never delivered. Berman was downright homophobic. Someone mentioned the skants were supposed to show gay crewmen which is as nutty as saying a woman in pants is a lesbian. It was just a sign of changed gender norms.
And outside of Yar, whose actress quit because she felt like wall decoration, the women were all caregivers. Sure men have always played doctors in the show, but Bev was specifically a mom.
People say the 80s were conservative, but Gene was no Reganite and he was syndicated, meaning he had a lot of freedom. Meanwhile, network shows like Golden Girls, Designing Women, and Murphy Brown were exploring issues like race, abortion, homosexuality, family dynamics, and feminism with way more depth than TNG. Plus, a third of TNG is Clinton era and it actually got more bland and conservative, not less.