The subject of football and all its attendant paraphernalia makes for a surprisingly joyful exhibition