Report claims “net zero backlash” has been wildly exaggerated, with politicians and the media fuelling public anger that may not even exist, despite most Britons still backing climate action