The Oscar-winning director wanted to make a 007 film as his follow-up to ‘Tenet’