How to set up fine-grained admin permissions or limit export capability?

I do not think so - admin actions can’t be restricted, since they have absolute control over the forum. Why do you want to prevent admins from making a backup via the UI?

Also, are you using Configure automatic backups for Discourse to automate backups?