It’s not like DNS is a huge burden by itself, it’s just approach of avoiding creation of critical services unless they become necessary. Because infrastructure around them is a burden: they needs additional firewall rules on middleboxes, monitoring, redundancy, IaC, backups etc.
I am not speaking about maintainance of DNS zones (that’s easy), but about maintanance of authoritative DNS servers.