DNS is only single-point-of-failure if you're soley using a DNS server you have no control over (Google or Cloudflare) and have no fallback servers. DNS architecture is quite resilient due to its distributed nature.