New exhibition at the Queen's Gallery tells the story behind the photographs and also reveals a royal connection