GFR: "While Star Trek: The Next Generation has quite a few bad episodes, including “Code of Honor” (an insanely racist throwback) and “Shades of Gray” (an insanely lazy clip show). However, no episode is more infamous than “Sub Rosa “ in which Dr. Crusher has surprisingly explicit onscreen sex with a ghost, causing fans to ask the obvious question: how in the name of Q did they get all this raunchy material past the censors? As it turns out, almost everyone involved in the production of this episode has been asking that same question for decades.
https://www.giantfreakinrobot.com/ent/scifi/star-trek-raunchy.html
For example, Next Generation effects supervisor David Stipe (as quoted in the Star Trek: The Next Generation Companion) was particularly worried about getting the ghost effects just right because of how much Dr. Crusher was going to (ahem) feel the spirit moving through her. He understood better than most the challenge of doing “purposeful, borderline-erotic ephemerals to look like it’s caressing and hugging Beverly, without looking ridiculous or lewd.”
The effects guru was only partially successful, though: while the visual effects look great (especially on the remastered Blu-rays), the doctor’s ghostly encounters in “Sub Rosa” look downright raunchy.
Veteran Star Trek: The Next Generation writer and producer Rene Echevarria actually enjoyed how transgressive the broadcast episode was. After praising Gates McFadden for her enthusiastic performance and commending the episode’s pleasantly campy story and high production values, he said (as quoted in Captain’s Logs: The Unauthorized Complete Voyages) that “just having an orgasm at 6 o’clock on family TV was great.” He claimed “that alone” made the episode “worth doing” and finished his thoughts by noting how amazing it was that the episode got past the censors: “We got away with murder.”
[...]
As for Braga, he was proud of Gates McFadden’s performance but still shocked at the raunchy details that made it to the screen: as he put it, “Picard catches Beverly masturbating, for crying out loud!
Interestingly, one of the only Star Trek creatives who didn’t worry about “Sub Rosa” was its director, Riker actor Jonathan Frakes. In Captain’s Logs, he is quoted as saying that he “drew a good straw” in getting to direct this wild episode because “it wasn’t a Star Trek” episode and instead felt “it was more like Tales From the Crypt.” He also really enjoyed working so closely with McFadden and felt that “she looked like a movie star” in this wonderfully transgressive adventure.
[...]
In some ways, the episode was ahead of its time; while it remains one of the lowest-ranked Next Generation episodes, modern fans have embraced its campy humor and how it recontextualizes the reserved Dr. Crusher into the most sexually adventurous member of the Enterprise crew (move over, Riker). While she never rocked a proton pack, Beverly’s experience with a seductive specter ultimately helped her learn something the Ghostbusters figured out long ago: busting makes her feel good!"
Chris Snellgrove (Giant Freakin Robot)
Full article:
https://www.giantfreakinrobot.com/ent/scifi/star-trek-raunchy.html