To use something I heard in a sermon yesterday morning, from a United Methodist Pastor who happens to also be very much a fan of ST in general, and SNW in particular,
Rocks are hard. Water is wet.
He spoke of such things both as ways to de-escalate arguments, and as a way to gauge whether somebody is disagreeing just for the sake of being disagreeable, or for the sake of "powning."
I will also preface my attempt to de-escalate the rather heated argument by noting that I misspoke, when I said that I'd first encountered TOS "almost exactly a decade after its network run, when I was in high school." I was in fifth grade, concurrently with the 1972-73 TV season, and so I was quite a bit closer to the social mores of the time. (I even remember my first encounters with TOS: the first partial episodes I saw were the end of "A Taste of Armageddon" and the beginning of "Space Seed." And the first complete episodes I saw were "The Devil in the Dark" and "Operation: Annihilate."
I think you're asserting a nonexistent distinction. That's exactly what a family show is -- not a children's show, just a show that lacks strong sexual content, violence, or profanity so that it's suitable for children to watch alongside their parents. It's what the British would call a "pre-watershed" show.
That is actually more-or less my own definition. I might elaborate upon it and say that a "family show" is one that (1)
generally lacks content that might traumatize children, or encourage (based on the social mores of the time) unacceptable behavior in them, and (2)
contains content that children would find engaging enough that they would not be bored to tears.
I will now make my points:
1. A television show (or any other form of entertainment) does not have to be
specifically intended for a family audience, or for unsupervised school-age children, or even unsupervised preschool-age chidren, in order to be
suitable for those audiences.
Jeopardy! is not a children's show by design, and yet it's entirely suitable for children. Ditto for
Evening at Pops. Or a broadcast of a figure skating competion, or a baseball game.
2. Just because a television show (or a movie, or a book)
is specifically intended for a family audience, or even for an audience primarily consisting of unsupervised children, does not mean it is not of interest to adults. I grew up on Captain Kangaroo, from years before the original "Treasure House" set gave way to "The Captain's Place" (and I have distinct memories of well-known ragtime pianists making guest appearances on one episode, and of Apollo mission coverage actually being incorporated into another episode), and I would put the storytelling, and the comedy, and the music, and the occasional educational content, as being at least as good as most primetime television. I didn't grow up on Mister Rogers Neighborhood (I'd barely even heard of it while I was growing up), and wasn't exposed to it until I was a junior in high school, but I recognized the quality of the series immediately, and I still watch it regularly, at nearly age 62.
3. Just because a series is
generally unlikely to traumatize children doesn't preclude the occasional exception. I was in 5th grade, the first time I saw "The Man Trap." I was in my 40s or 50s the second time. It severely traumatized me as a 5th grader, and if I hadn't already seen beautiful episodes like "The Devil in the Dark" first, I might have given up on ST. The idea of a hungry predator, with an appearance that is utterly hideous by all Human standards, stalking the crew, luring them to a particularly excruciating and gruesome death by mimicking their most trusted friends (or in Uhura's case, mimicking a fantasy), was made all the more traumatizing by the simple fact that the Salt Vampire's "Young Nancy" guise bore a more than passing resemblance to the music teacher who serviced my elementary school at the time. And it didn't exactly help matters that Courage wrote an exceptionally creepy score for the episode, prominently featuring a crude electronic "organ." By the time I could finally bring myself to see the episode again, I was older and wiser, and realized that a lifeform that metabolized salt, in such a way as to permanently remove it from circulation, was as ludicrous as Doc Smith's notions of iron (literally the most stable element on the whole Periodic Table) as a source of energy, or radium as an appropriate metal for currency or jewelry.
4. Even television shows that are intended for children may still traumatize some. I distinctly recall that
Gigantor terrified me.
Just seeing the open for the series was enough to drive me to watch something else,
anything else.
5. Getting back to TNG specifically, yes, there was quite a bit of sexual content, and not just in the first season. Tasha seducing Data in "The Naked Now." Geordi and Tasha's lines in "Justice," about how the people of that particular crapsaccarine (as it ultimately turned out) society "make love at the drop of a hat . . . any hat." Okona seducing (as I recall) and attractive young transporter engineer. Riker's practical joke of asking Picard to buy what turned out to be a Risan fertility idol, in order to guarantee that he'd be continuously showered with proposition after proposition. But even the worst of it was far more tasteful than, say,
Three's Company, which I deem to have been a total waste of the late John Ritter's acting chops, all for the sake of tasteless "cutesy sex" jokes. Nor did I find even the worst of the violence to be any worse than I'd seen in some of the more violent police procedurals, or the William Dozier
Batman, or
Rocket Robin Hood. All in all, I would not regard any of the sex, violence, or nudity in TNG sufficient to make it unsuitable for family viewing. And evidently neither did my younger cousin, who had no objections to her toddler son becoming a fan of the series.
Now I would not consider DSC (especially the second season, thanks to the Section 31 arc in general, and the "eye-scream" in, if I remember right, "The Red Angel") or PIC to be suitable for pre-high-school-age viewing. And I certainly wouldn't regard most of LD to be suitable for family viewing, either, because of the often-tasteless sexual humor. But certainly all the ST series that have enjoyed a broadcast run could be regarded as such, and so could SNW, given
today's social mores.
As to LGBTQ+ in Berman-era ST, he may very well have been homophobic. But on the other hand, unless a character is stereotypically "camp gay," there isn't much opportunity to show a character's sexual orientation without establishing a romantic relationship, and we didn't see
all that many strictly heterosexual relationships in Berman-era ST, either. Some, to be sure, but not like what you're seeing today. And back then, it wasn't exactly the norm, in action-adventure storytelling, to delve deeply into even the regular characters' love lives, much less those of on-shot guest characters.
Emergency! (which I grew up on, and have on DVD) certainly wasn't anything like
Station 19 (which I've seen) or
Rescue Me (which I've barely even heard of). That Berman-era ST was way behind the sitcoms in terms of having LGBTQ+ guest characters, and treating them with dignity, is a given, and it's an injustice. But it did occasionally bring up those issues allegorically. Dealing with an issue allegorically is better than not dealing with it at all. And not dealing with it at all is better than dealing with it hatefully.