First some info: I did reproduce this, so I have actually verified this happens (to me at least).
Lets go. Here is my CAA info, which I have with every domain I host:
@ IN CAA 0 issue "letsencrypt.org"
@ IN CAA 0 issue "sectigo.com"
@ IN CAA 0 issuewild ";"
@ IN CAA 0 iodef "mailto:firstname.lastname@example.org"
Most of my domains use Letsencrypt, but some use Sectigo certs, hence both there so I can change certs if needed without editing dns records.
Now, when I renew manually or cert gets renewed automatically (Letsencrypt), the corresponding CAA record, in this case "@ IN CAA 0 issue "letsencrypt.org"" gets removed from the records for some reason!? This obviously prevents next renewal after two months or so, and I get e-mails saying renewal failed because CAA prevents it.
I don't know why cert renewal even messes with dns records, but this is what happens.
Hope the issue is clear enough, thanks!