improve healthCheckExprs for CNPG Clusters

!7315 (closed) was brought up to improve healthCheckExprs for CNPG Clusters, but we need a proper issue to track this improvement for main, and its backports

It's important to have in mind that we have many units making use of CNPG, not only keycloak.

/cc @teodora.pirvan

Edited by Thomas Morin