What it actually assesses
Not just flooding. A climate assessment looks at the physical effects expected from long-term changes in temperature, rainfall, humidity and wind — increased flooding, increased subsidence, increased coastal erosion, and other effects on land and buildings.
Subsidence is the one most often missed and the one with the clearest insurance consequence. Clay soils that shrink in prolonged dry weather are a well-understood mechanism, and a property on clay with trees nearby is a known pattern rather than a speculation.