"And it's Hi, Ho, Sheffield Wednesday" is another crap one, not because that line isn't memorable, but because nobody could be arsed to come up with a decent second line. "I see your sun is shining" sounds spectacularly rubbish after that.
It's like they saw other clubs playing "their" tunes & just plucked the first vaguely memorable song that sprung to mind out of the air. Assuming they were playing Sing-Along-McCartney roulette, they're lucky the ball didn't land on the Frog Chorus.