The late Queen Elizabeth was consistently a seriously popular figure in the UK, but few aspects of her private personality were ever on show - until Kate let one slip