Gah you are so right with that. Between the first Trill episode and the non-binary planet episode… just a rough time for queer Trek. At least we got some good stuff with DS9, though even the head writer wishes they pushed the envelope a little further.
I’m hopeful we can get some better stuff out of Strange New Worlds. While Disco had more representation, I did not care for that show for a myriad of other reasons.
Why isn’t there more prog rock? Styles change. There’s still smaller prog rock bands starting and playing shows, they’re just not selling out MSG like they did when that genre was in vogue.