Cloud diagnostics may fail due to wrongly interpreting parametric vertical coordinates

There are many (20 out of 50) failures in the `cloud-scatterplots-cli-ta` diagnostic: https://dashboard.climate-ref.org/diagnostics/esmvaltool/cloud-scatterplots-cli-ta/groups

I suspect several of these are due to https://github.com/ESMValGroup/ESMValCore/issues/3056, even if the error messages vary. Some of these may be data quality issues too.

Example failure: https://dashboard.climate-ref.org/executions/45/logs

The run fail with
```
esmvalcore.cmor.check.CMORCheckError: There were errors in variable cli:
There are multiple coordinates with standard_name "air_pressure": ['ps', None]
```