“If you do everything perfectly you won’t have security problems.”

But people make mistakes. Human error and misconfigured servers is the cause of many security flaws. Especially people asking “what should I provide for DNS on this domain registration form?”

DNS services are dirt cheap. Hosting yourself requires some knowledge to run security, and you need a static IP address to host one which many people don’t have.

Best not to do it yourself.