A new exhibition reflects on the haunting aesthetics of human impact on the planet