The Duke and Duchess of Sussex stepped out at a glitzy fundraiser in Canada to support their music mogul friend David Foster for an important cause