Opening at a time when severe flooding north of the city, the exhibition uneasily aligns with a state of national emergency