The Director of the US Central Intelligence Agency (CIA), John Brennan, has expressed pessimism about the future of Syria.