In the late '80s his popularity could hardly have been worse, thanks to the disastrous TV show It's a Royal Knockout. But after a royal reinvention (and some help from his wife, Sophie), the Duke ...