It's hard to imagine now, but half a century ago the reputation of the late Queen's only daughter had all but hit rock bottom, and she was unpopular with press and public alike.