The actor, 42, who very narrowly missed out on playing the iconic character to Daniel Craig (pictured in No Time To Die), has been in the running for the past few years