I've never really used NetworkManager on my personal setup but if you're using it, you are willingly giving control of your network settings inside /etc to it, including the DNS, which is why /etc/resolv.conf gets changed automatically. You can choose not to use NetworkManager or systemd-resolvd (while still using systemd) and they won't mess around with /etc/resolv.conf.
For network management, I do use systemd-networkd and it hasn't overwritten or changed my files in /etc/systemd/network in the past 6 years of me using Linux, not that I recall at least.
It's upto you how you manage your settings in /etc. A software will never modify anything in /etc without your choice.
Hell, the simplest thing you can do is not use either NetworkManager or systemd-resolved and edit /etc/resolv.conf to point to your favourite DNS server. That file will never change automatically and you can use whatever DNS you want.