All things decay at France’s biggest biennial, an exploration of fragility and resilience that tends towards the spectacular