> These attempts overshoot at times, like when Star Trek TNG

On the other hand the entire run of the "progressive" Star Trek didn't have a single gay character until 2016 - not even in guest stars (well there was the whole Dax/Trill thing, and the "non binary" character with Riker)