I have been doing a daily rotate/revoke/publish routine with my DKIM keys for years, though I do not use the standard private key format for size reasons.
No problems with it, but critically I revoke the public key a few days before publishing the private key.