I think Lilmod made an excellent point- shouldn’t the purpose of Jewish music be to inspire people and give them his’orerus? If the words and the tune work together to accomplish that, then great. But if one or the other doesn’t inspire people, but is just the Jewish equivalent of a goyish dance beat, then what type of chutzpah is it to take words from Torah sources and exploit them to that end?
Obviously, each person has different sensitivities, but I think most people can tell if a song was meant to be me’orer people or not.