CAA record is not very important, you can skip adding it if it’s impossible. But may be better to switch to another DNS server in any case because there is no reason for not being able to setup CAA records. If DNS provider cannot provide an interface to add CAA records they likely don’t care much about their DNS service.
For the reasons to add CAA records you can read