Despite 50 years in the business and multiple Oscar wins, the veteran director still struggled to get funding for his latest film, which will make its debut at Cannes. Here, Geoffrey Macnab looks at why the man who brought us ‘Apocalypse Now’ and ‘The Godfather’ will always be an outsider