Expand Secret Revocation to support private repositories
### Proposal
With the work completed in https://gitlab.com/gitlab-org/gitlab/-/issues/371658 we will now auto-revoke leaked PATs in public projects. We should explore expanding this support to auto-revocation leaked pats in private projects, as well.
Based on https://gitlab.com/gitlab-org/gitlab/-/issues/385690 we should consider whether to enable this behavior by default or make it opt-in
#### Links
- See recent (non-public) [Looking forward discussion](https://docs.google.com/document/d/1nRsp76-TCG3oUTk4245Lw_kvVuj-nc3tSsRCzhE5jXE/edit#bookmark=id.t2jn0xs04wzd)
- [Logic limitation revocation to public projects](https://gitlab.com/gitlab-org/gitlab/-/blob/2431aabb3c42935974fc881d7d0d46a3e4d4011a/ee/app/workers/store_security_reports_worker.rb#L36)
issue