During her 19-year tenure as its director, she turned a sedate institution into a vibrant tribute to the culture of 18th-century France