While Labour is favourite to snatch the Northamptonshire seat from the Tories, Sunak’s party faces a battle even to take second place, if local opinion is anything to go by