Although her unusual career might have been accidental, the Duchess had a lifelong passion for music