The United Nations (UN) is no longer fit for purpose because it is still trying to resolve the world's problems as if it were 1945, Saudi Arabia's Prince Turki Al-Faisal told CNBC on Friday.