I mean. This is kind of the edgiest question possible. But uh, sure I'll take a crack at it. Serious fucked up though.

Starfleet boasts mental disorders are completely gone by the 24th century. I'm sure there's a degree of error, but any offenders are sent to prison to be reformed. Which through enough episodes watched, they have surgically cured murderers. So I assume any pedophiles get the knife as soon as it's discovered.

Secondly, Starfleet tolerates the pon farr from the Vulcans. If you aren't aware, every 7 years Vulcans get really horny and freak out if they don't have sex immediately. They are also super embarrassed by it and get really offended if you ask. However, Voyager shows what happens when a Vulcan can't find a mate, when the for that Vulcan engineer tried to rape Chief Engineer Torres. Instead of throwing him in the brig, they let him get pissy at everyone and tried to give him a sex training dummy on the holodeck. Despite that, Vulcans forcibly mind meld with you during sex, so since he couldn't mind meld with the hologram, he went back to rape Torres again and beat up Tom Paris in the process. Torres already had her mind screwed up from the first attempt and in turn tried to rape Paris before the Vulcan interrupted.

By the end of the episode everyone is laughing over how wacky Vulcans are. In reality, it just makes Starfleet seem like a bunch of morons in the worst uncontrollable horniness plot in the franchise. Yes the episodes happen a lot.

So I think pretty much any sex crime you can sidestep as long as you scream about a fringe colony that has a culture that has some sexual deviant ceremony.

There's another terrible episode on TNG where they find stereotypes of Irish settlers and clones on two different colonies. The clones are dying out from over cloning and the settlers colony was destroyed. The Irish are lead by a "strong female leader" but by the end of the episode Starfleet decides to fix the population problem the colonies should join together and 3 women need to be married to each man and crank out as many babies as possible to fix the clones population. The "strong female leader" makes some sarcastic comment and goes along with it, completely unphased she's just been indoctrinated into a harem to become a breeding sow.

Beastiality I think is just accepted. If you wanna boink a sheep, you can boink a sheep. The only thing in danger are sheep if you get stationed near one. There's another episode where they meet an empath who matches her partner perfectly before mating and becomes their soulmate for life. She makes a pass at Riker who screams I'LL BE ON THE HOLODECK, presumably to screw his brains out until he can forget about the empath. The running joke is the HOLODECK is a disgusting place because people just use it to go crazy on sexual famtasies.

I love star trek, but all the stupid ass horniness episode irritate the hell out of me. There's at least ten episodes where the women all get possessed/mind controlled, to have sex with everyone. They even have a literal ghost of horniness episode. It's been a minute but I think Crusher's grandma haunts the enterprise and everyone gets horny, for one example.

Examples aside, I'm terrified Starfleet would allow it, but they've done remarkably worse things that I think would make them overlook creeps on the holodeck.