Pubs can ban whatever they want, but of course patrons who want to hear the song will go elsewhere.

Same for pipers. If you don't like playing Amazing Grace, then don't become a piper for hire. Businesses serve their patrons, not the other way around.