Former deputy secretary of state William Burns says president’s disdain for career diplomats, intelligence services comes at a time when “we need diplomacy more than ever”