Bump major and simplify Secret Detection script

Bump major of secrets and simplify Secret Detection script logic to match changes made for Secret-Detection.gitlab-ci.yml Changelog: changed

Related to #359042 (closed)