The song you mention just doesn't sound like a very good song! As an atheist, I can imagine singing a song celebrating how good it feels to be filled with the Holy Spirit - just not one that says "you lot aren't going to be saved and serve you right".

Protagonists of traditional songs get into some quite extreme situations. I can be singing about people committing robbery, adultery, rape, murder, suicide, incest, or various combinations of the above, and I'm right there - you need some imaginative identification to make the song work.

I think the key is identifying with the emotions of the song, however extreme the situation is. I like "Sheath and knife" ("I've just buried my sister, who had given birth to my son, and now I can't tell anyone about any of it"); I don't like "The shearing's not for you" ("I raped her, she's pregnant, I'm off"). The first has a much more extreme (and unusual) situation than the second, but the character's emotions are much more sympathetic.