TNG was infected with the Modern Liberal Politically Correct Bug. Remember when it first started, they had a Female head of security? That's just politically correct stupidity, and that character didn't last long.
There were Two episodes of it I found particularly offensive.
Remember when Riker fell in love with the homosexual Alien? To be fair, the Aliens of that Planet were supposed to be "Sexless" but this one in particularly just happened to look like a beautiful Woman, and other Aliens happen to look either Feminine or Masculine, but the species were supposed to be "neutral", being neither female or male, and so therefore a "neutral" thinking it is female is analogous to a homosexual in normal society.
That's what the writers were going for. You could tell from the dialogue that they were attempting to "normalize" the idea of people not adhering to normal gender roles.
The Second Episode I found particularly offensive is when An Admiral is assigned to the Enterprise to find a research ship that went missing years earlier.
The "Secret Agencies" at the Federation were doing research on a sort of Cloaking device that would allow a ship to "ghost" and go through ordinary matter. They find the ship, and the Admiral attempts to gain possession of it and get it back to the Federation.
Riker deliberately disobeys direct orders, Transmits a signal to enemy forces (Either Klingons or Romulons) and hands the technology over to them, because he takes it upon himself to enforce a Treaty contrary to the direct orders of the Admiral in command.
Rather than be instantly court marshaled and shot, as would anyone who did such a thing in an actual Military organization, Commander Riker is not even given a slap on the hand.
I recently ran into a cartoon in which a chubby little boy says, “I am a woman” or something. There were two other female looking characters with him. One was named Sapphire and they fought all the time. Creepy, and it seemed like an attempt to genderbender kids.