John Brennan says president who made volatile remarks about destroying Iranian civilization ‘is clearly unhinged’