Chancellor acknowledges disastrous state election results but vow to push on is likely to further alienate voters, and his own party