In one of his final appearances as a senior member of the royal family, he joined Jon Bon Jovi to meet a British military veterans' choir