To me, a major reason not to use Simon and Garfunkel, or some of the prettier Beatles, say, is that people won’t hear the words of Lecha Dodi, they’ll hear the secular songs.
When a rebbe of old bought a tune he happened to have heard from a shepherd, that tune wasn’t necessarily something that was part of the hamon am’s conscience.