An exhibition at the Metropolitan Museum of Art joins recent works with centuries-old art to explore death and what comes after