The issue isn't casually talking about your family or partner. Most people save for the uber religious don't care if a teacher discusses their same-sex partner as in "my husband/wife took our kids shopping for our weekend trip." Most people won't even care if teachers answer questions students ask to clarify. "You're married to a woman?" "Yes, and I love her very much," etcetera.
He probably grossed himself out describing all that and is now in spiritual detox. I'm sure he will elaborate once the priest has exorcised all the evil spirits.
Neither of those are LGBT+ issues, for the record. I know one or two of the stories you're talking about, one that was a drag performance and another about a book with a same-sex relationship, but the issue with either of those had nothing to do with their connection to LGBT+ topics--at least it shouldn't have been, but they were treated that way. They should've been handled just like anything else inappropriate in a school, but at large, the problem was treated as them being drag or having LGBT+ characters.
There's no need for legislation for this kind of thing because the same things that are inappropriate for queer people to do in schools are already inappropriate for cis/het people to do. I'm not saying that in disagreement with what you said, just pointing it out in addition.
Except if you changed those situations so the acts were the same, but the people involved were all straight and cis, they'd still be a problem.
Them being LGBT isn't the problem. Them having NSFW content is, regardless of the specifics of that content, and the identities of the people involved.
I don't think what you're saying is true. I know someone who very actively doesn't want mentioning of gay people to kids. For context, he's foreign-born, isn't otherwise conservative, and has been a US citizen for probably longer than most people on Lemmy have been alive.
I mention this anecdote because it's part of many anecdotes and the vast majority of people in his community have viewpoints that I've heard and are much more extreme than his.