Spymaster called emerging agreement 'a strategic disaster' in remarks that were not coordinated with prime minister and differed from official talking points, report says