After British PM remains supportive of ambassador who described US leader as 'inept,' president says 'good news' is that UK will soon have a new premier