I'm just an individual, so my opinion may be just that. My opinion.

To answer your question, families may ban the use of said words in the sanctity of their own homes, for example.

The only reason I may feel that curse words are inappropriate in any situation is because I'm already conditioned, from childhood, to think of them as "they may offend." But if no such conditioning existed, I'd say they would be okay in any instance, because the words per se are not offending. The intent is.

Take, for example, an eulogy. A person speaking of someone who recently passed away, may say "Excuse me everyone, but gosh darn, why did he have to leave so soon? I feel like a failure, because I could have done more. I'm a failure!" Why should it be different from "Excuse me everyone, but fuck, why did he have to leave so soon? I feel like I fucked up because I could have done more. I'm a fuckup!" Really, the only reason we may silently gasp at the second version is because we were conditioned to "gasp" at those words while growing up. Not because the words cause actual psychological, irreparable harm.

You touched the topic of religion in other comments. I guarantee you that when God, before killing everyone with a flood during Noah's ark times, I'm sure He at least, at the very least looked at the state of the "failed world" and said "well, shit!"