Sorry, I can't tell for macOS, but on iOS i have a few DNS profiles and they all seems to work.
In addition to running a VPN? That's what the main comment was about, wasn't it? The profiles alone do work.
As I understood it was about blocking content (via DNS) *even without a fake VPN connection*. Once you run a VPN connection, most likely its DNS takes over, profile or not profile.
The very thing you're linking to is because of running conflicting software on MacOS.
Yes I know but that's what the parent comment(s) are about? Using a profile for DNS settings instead of a fake VPN because you can't run more than one active VPN at a time.