Upgrade cloudnative-pg operator to v1.24.0
This allows us to benefit from https://github.com/cloudnative-pg/cloudnative-pg/commit/24f0297367f65cebddf79af302a865807726419e in which seccomps are automatically assumed to be available whatever the Kubernetes version.
We need this because we run Kubernetes 1.23 but we have seccomp enabled as prep work for a future Kube upgrade. In the previous version of the operator, the specified seccomp was silently ignored, which causes policy violations when scheduling the pods.
Bug: T369492