Queen Elizabeth II might have seemed reserved, but the life of Britain's longest-reigning sovereign was far from quiet