Royal weddings provide a national sense of celebration around the world, and while many have ended happily, others have not.