Now on show in the US, this enigmatic masterpiece is more than a still life: it's a record of the family's life and times