George, I call it a pub hymn because while I've always liked the song, the few times that I've heard it sung in church it has seemed out of place - the congregation seemed self-conscious singing it. On the other hand, I was once down at the Old Dublin Pub close to Easter and the band did Lord of the Dance and lots of people were up to dance - it felt just right then.Speaking of Michael "Liberace on Speed" Flatley, his work just seems in poor taste to me generally. I do Celtic stepdancing myself, and it's definitely not supposed to be a male nipple dance.
(I don't mean to come across as a total purist - I loved Riverdance even though they move their arms sometimes.)
But I think Flatley's appropriation of the title "Lord of the Dance", which refers to Jesus Christ in the song, goes beyond tacky to irreverent.