According to the following website, it's Hava Nagila:

http://tvtropes.org/pmwiki/pmwiki.ph...gFreakingGrace

Says the same thing here -- probably the source for the above:

http://www.weeklyscript.com/South%20...0Wee%20Wee.txt

Maybe the piper took the "horribly" comment and ran with it