Yes — CAA only restricts which CAs can issue. If you list Let’s Encrypt and DigiCert in CAA, both can issue for your domain. If you list only Let’s Encrypt and later try to get a cert from Sectigo, Sectigo will refuse. Update CAA to include the new CA before requesting a cert from them.
All questions