remove op-specific SCCs from helm templates

[razvan]

Description

Cleanup tasks after release 24.7.0 to bring Helm and OLM closer together.

Remove custom product SCCs from the Helm charts and use nonroot-v2 instead.

Related issues

• Investigate getting rid of custom SCCs #607

Tests an CI

Hbase integration tests which include several other ops:

--test-suite openshift \
--operator secret=0.0.0-pr488 \
zookeeper=0.0.0-pr852 \
hdfs=0.0.0-pr573 \
opa=0.0.0-pr620 

Operators

• commons-operator
• listener-operator
• secret-operator: fix(helm): use the same scc as olm secret-operator#488
• zookeeper-operator: fix(helm): use the same scc as olm zookeeper-operator#852
• opa-operator: fix(helm): use same scc as olm opa-operator#620
• airflow-operator fix(helm): use same scc as olm airflow-operator#487
• druid-operator fix(helm): use same scc as olm druid-operator#614
• hbase-operator fix(helm): use same scc as olm hbase-operator#547
• hdfs-operator fix(helm): use same scc as olm hdfs-operator#573
• hive-operator fix(helm): use same scc as olm hive-operator#504
• kafka-operator fix(helm): use same scc as olm kafka-operator#749
• nifi-operator fix(helm): use same scc as olm nifi-operator#663
• spark-k8s-operator fix(helm): use same scc as olm spark-k8s-operator#449
• superset-operator fix(helm): use same scc as olm superset-operator#527
• trino-operator fix(helm): use same scc as olm trino-operator#630

[sbernauer]

Everything done :)