As a working editor, here is what happens when I get a manuscript. First, slang terms for the butt and other normally covered body parts are straight out. Slang words for bodily functions are right out. Calling someone a slang word that falls under profanity is right out. Using God’s name in vain is out. I either cross out the word, write in a substitute word or phrase, or otherwise partially rewrite the sentence. Art is not a get out of jail free card.
Prior to 1970, you had crime dramas, police/detective shows, science-fiction and plenty of villains on TV. Most of it was good to very good, and zero profanity/cussing and swearing.
The company I work for has been producing mostly fiction for a long time now. We understand who our audience is and we do not want to add to the “freedom” some people wanted in the late 1960s. Silly me. At the time, I thought they had some high-minded goal. Nope, we get sexual situations, “adult” language, and other immoral behaviors and bad behaviors acted out as good, normal or average. No need for any of that. We chose to be family friendly. We chose to produce work that would appeal to a wide age group without offending most people.
I also have a visual arts background. I associated with real artists for a time. I took art classes in college. And I work with writers and artists now. Things were pushed in a wrong direction regarding fiction, followed by non-fiction. I never thought I’d see the day when I would throw out a non-fiction book, but I did. Some author decided to do a book about the work of an attorney regarding a subject that interested me. This author used up 15% of the book to mention the sexual antics of various people. Totally irrelevant in the context of the entire book. I would have cut that 15% but I was amazed that a “real” publishing company left it in. Not in my library.
Fan fiction, most of it, has been described this way: it has all the sex scenes that were never part of the original. It is called a “derivative work.” Now, some well-known authors and studios are against it, others are for it and others are neutral. In other words, they know it’s out there, but they do not take a position. On the other hand, a few actively pursue those who distort/pervert their copyrights.