Irish actor Michael Fassbender revealed that he was in the running to replace Pierce Brosnan but ended up promoting Daniel Craig instead of himself, ultimately missing out on the role