Things turned out disastrously for the last American who married into the British Royal Family