An 80-year-old American cowboy, who advises the Queen on her horses and dogs, has revealed the Monarch's sense of her own mortality is behind her decision not to have any more corgis.