Jefferson Airplane’s “We Can Be Together” contains the line “Up against the wall, motherfucker”. You could argue that the entire phrase didn’t need to be in there (it seems at odds with the overall message of the song), but once you use that phrase, ain’t no other word going to stand in for that last one.
I ran into something similar years ago when watching a video of a Bill Cosby live performance. He was talking about asking a cocaine-using friend, "Why do you do that? What does it do for you? The friend answered, “It enhances your personality!” to which Bill responded, “But what if you’re an asshole?” It was just so unexpected, given Cosby’s usual “clean” comedy, that it was that much more powerful than it would have been coming from a comedian who swears all the time.
I’ll add The Eagles’ “Life in the Fast Lane”, with its line, “We’ve been up and down this highway, haven’t seen a goddamned thing.” I don’t think I’ve ever heard that censored.
It was years before I noticed that the line appears twice (once after the second verse and again after the last verse). It’s a bit like John Lennon’s “Working Class Hero,” where Lennon, having recorded the song in two halves that were spliced together (the edit is obvious–the sound changes quite noticeably), didn’t realize until he heard the finished recording that he had used the word “fucking” twice.