There aren't many hockey rinks left with mostly organ-based entertainment (alas), but I was thinking about the usual staples and wondering how a Jewish folk song like Hava Nagila became one of those "you hear it every game" songs.
Same question about the Mexican Hat Dance too, but I would imagine that one's just "because it's lively".
As others have noted, it's upbeat with a rising tempo that gets the crowd into it. And it's not exactly obscure - you hear it everywhere, not just Bar Mitzvahs. I know I get it in my head a few times a year and it just won't leave.