Hello @EnterpriseArchitect,
Thank you for posting your query on Microsoft Q & A Forum.
As per my understanding, you wanted to know the best practice to avoid performing manual rotation of the client secret values.
Unfortunately, we cannot automatically renew a client secret for an app registration and admin should manually create a secret before expiration and update it in the application server.
The document you are referring to rotate the secret is for internal function apps and storage accounts which can be directly linked to a key vault. This would rotate the client secrets, but these are for internal resources like VM's, function apps etc.
We can link the app registration with Key Vault which would automatically renew the secret but updating this in the application server would be again a manual work.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query, please do let us know by commenting on this.