Roddenberry's "Star Trek" was less about demonstrating the dynamics of a future societal set up as it was with questioning the existing societal conditions that might be detrimental to individuals and classes of people.

Following a lead that began with Rod Serling's "Twilight Zone", writers, producers, and directors adopted the tactic of presenting difficult issues in science fictional contexts. By subtly couching social ills like racism, sexism, ageism in other-worldly settings the audience could critique, laugh, or otherwise assume a superior morality while judging the insanity of prejudice without having to confront their own innate biases.

It's an ages old literary trick to stimulate the mind into considering fresh perspective that wouldn't ordinarily arise. Shakespeare employed these shake-ups in many plays to much comedic and thought provoking effect.

After much research and digging I can find no indication that Seven-of-nine was homosexual. Indeed, the character made many attempts to explore her human sexuality through interactions with Chakotay, Tom Paris, and Harry Kim. Even the holographic doctor aided the former Borg drone in her search for her humanity. This focus on males strongly suggests that the character was seeking hetero-sexual companionship. There was, of course much fan speculation that Seven-of-nine had an unrequited possibly sub-conscious attraction to captain Janeway but there was never any exploration of this except in the rather bawdy fan fiction productions that would depict similar liaisons between Kirk and Spock or Picard and Data.

I find it interesting, however, that Star Treks much vaunted and proud acceptance of tolerance and diversity wasn't extended to the Borg. Since there could be no detente or accommodations to be had with the collective in their assimilative philosophy of self improvement through integration of cultures with their own. It would seem that universal diversity, tolerance, and inclusion must have its limits.

Another aspect of the series was the manner in which, after humanity achieves warp capability under the firm but benevolent guidance of the Vulcans, the establishment of the United Federation of Planets was a Terran enterprise that soon had the human beings becoming the ostensible face of that organization. This, in spite of the fact that the IDIC philosophy was a product of the Vulcan culture. IDIC stood for, Infinite Diversity through Infinite Combinations. A philosophy rooted in the strict mathematical reality of infinity and the possibility of all conceivable outcomes.

A particular episode which was intended to display the damage that was being done by the apartheid policies of South Africa now known as Zimbabwe. The episode entitled "Angel One" depicted a culture wherein women were the dominant gender and all of the men were subordinate. The men were played by shorter less physically developed actors to emphasize the supposed effects of generational selection by the women. Riker was elected to negotiate with the leader of this society and was required to dress appropriately. The dress code for the men included the exposure of much chest hair and accentuation of other masculine attributes. Tight pants and bulging buttocks and, ahem, other things.

The episode was nearly universally panned by viewers and critics alike for its blatant pandering to stereotypes and sexual tropes. The attempt to criticize apartheid clearly missed the mark.

Challenging society's faults and failures will always be tricky and fraught with mistakes. Speculating on solutions and improvements will be as hit and miss as speculations about the future. Sometimes we get it right but more often we get it wrong.