A new sovereign can revive a royal family or be its kiss of death. So will the controversial successor to Queen Elizabeth II spell the end of Britain’s thousand-year monarchy?