Footage of Henry's 'tremendous' audition for the role of James Bond resurfaced 20 years after he very narrowly missed out on playing the iconic character