I'd say it's extra complexity that is not really solving any problem we have. Nostr is already pretty resilient against DNS issues.
But if someone is really out to get someone and Nostr isn't good enough then DNS isn't much worse than the entire IP protocol that relies on one central registry and hierarchy of addresses that is very permissioned.
If we are to spend efforts on this layer then I'd rather go for the entire IP thing and make it possible for networks to be assembled in decentralized and permissionless ways using local cables and wireless infrastructure, then merge together forming an ever-growing parallel internet, with decentralized routing that scales globally.
This is my idea: nostr:naddr1qqyr2wpjvd3kgvtyqyghwumn8ghj7enfv96x5ctx9e3k7mgzyqalp33lewf5vdq847t6te0wvnags0gs0mu72kz8938tn24wlfze6qcyqqq823c53smcd
But, if Nostr is already struggling to get a few users and not be irrelevant, imagine something like this.