In its originally intended context (Phoenix Nights) it was extremely funny, but the 'song' itself never got past the first verse and chorus. It was the reaction to it that got the laugh, rather than the song.