"but I think the lyrics of "Lord of the Dance" are trite - that's why they make me cringe."

Amen to that Joe. It's a masterpiece of the extended metaphor - pick an allusion that's essentially meaningless but in which people can invest some 'profound' stuff of their own, wind 'em up and watch 'em go. Even if the song wasn't terrible (which it is) it's been condemned by the company it keeps.
Perhaps we'll have a thread on Dark Satanic Mills and discuss whether it's racist, anti-Wiccan and patronising to overweight female players of overstrung pianos.