“Even if exposed or leaked, it is one secret to rotate rather than all of your secrets, scattered across all of your services and their environment variables.”
I don’t think this is true. You’d rotate all secrets in the store, as they could be accessed/compromised.