Rock legend Rod Stewart swapped stadiums for a non-league ground, paying £10 to watch his local team.