The head of the Council on Foreign Relations tells CNBC why the U.K.'s vote may spell the end of the European unity project.