Am I the only one who's annoyed by how common profanity is in every medium?

Not at all. You could write a whole post on that topic here on games alone.

Meanwhile, I have relatives who read Go the Fuck to Sleep to their baby every night because, "it's just words."

I can't understand parents like that, but most of the ones I've encountered were woke liberals. I doubt they'd still agree "it's just words" if the book was Go the Fuck to Sleep, Nigger.