Orphan secret on SecretProviderClass deletion

[RobinFrcd]

What steps did you take and what happened:

1. Create a SecretProviderClass
2. Wait for the secret to be created
3. Replace the SecretProviderClass with a new one
4. New secret is created, but old one is not delete

What did you expect to happen:
Old secret should be deleted

Anything else you would like to add:
My first issue was that a change in the SecretProviderClass didn't update the related secret. In my helm chart I implemented this solution: #389 (comment) (add a {{ .Release.Revision }} suffix at the end of SecretProviderClass/secretName). So it creates a new secret at every release but doesn't delete the previous one, so I end up with orphan secrets.

Which provider are you using:
AWS Secret Manager

[k8s-triage-robot]

The Kubernetes project currently lacks enough contributors to adequately respond to all issues.

This bot triages un-triaged issues according to the following rules:

• After 90d of inactivity, lifecycle/stale is applied
• After 30d of inactivity since lifecycle/stale was applied, lifecycle/rotten is applied
• After 30d of inactivity since lifecycle/rotten was applied, the issue is closed

You can:

• Mark this issue as fresh with /remove-lifecycle stale
• Close this issue with /close
• Offer to help out with Issue Triage

Please send feedback to sig-contributor-experience at kubernetes/community.

/lifecycle stale

[k8s-triage-robot]

The Kubernetes project currently lacks enough active contributors to adequately respond to all issues.

This bot triages un-triaged issues according to the following rules:

• After 90d of inactivity, lifecycle/stale is applied
• After 30d of inactivity since lifecycle/stale was applied, lifecycle/rotten is applied
• After 30d of inactivity since lifecycle/rotten was applied, the issue is closed

You can:

• Mark this issue as fresh with /remove-lifecycle rotten
• Close this issue with /close
• Offer to help out with Issue Triage

Please send feedback to sig-contributor-experience at kubernetes/community.

/lifecycle rotten