There's a little outfit I like called 'Gregorian' who as the name implies, sing in the (popularly accepted) style of the monastic order they're named after, or so I assume. They are the epitome of the notion that the cover changes the meaning. Here's a sampling:
Wonderwall, original by Oasis. Yes, it is possible to listen to Wonderwall and enjoy it without feeling like you need to shower because you gave money to Liam and Noel.
Sweet Child 'o Mine, original by Guns N Roses.
Boulevard of Broken Dreams, original by Green Day
Shout, original by Tears for Fears also....memorably covered by Disturbed
Heaven (guest starring Amelia Brightman), original by Bryan Adams, also famously covered (and frankly overall better sung) by DJ Sammy
Heaven is a Place on Earth, original by Belinda Carlisle
Hell's Bells, original by AC/DC. No, that's not a RickRoll (do people still do that?) or a typo.
And here's the song that has been successfully excommunicating people from society for not hating it.....
My Heart Will Go On, original by Celine Dion. Yes. THAT song.