The Duchess, who was married to the late Queen’s cousin, had retreated from public life in recent years