chore: remove detect-secrets dependency

What does this merge request do and why?

chore: remove detect-secrets dependency

We no longer scan input data for PII information so this can be removed.

• !40 (merged) introduces this dep.
• !787 (merged) removes the logic that uses this dep.

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

Merge request checklist

• Tests added for new functionality. If not, please raise an issue to follow up.
• Documentation added/updated, if needed.