Parish resigns over ‘moment of madness’, and claims ‘it was tractors I was looking at on the internet’