Marcel Theroux goes in search of the rebel spirit of Hamburg’s St Pauli football club, and finds fans fighting for the club’s soul