The cult comment was in jest. These are just package managers don't take things so seriously, it is all in good fun.
Yes, I understand the multiple versions of the same package thing - Go/Rust have package managers that quite reliably solve that problem. Pipx also to a certain extent solves that problem.
Brew is useful mostly for casks (browsers, mac apps, fonts) which don't usually call for multiple versions.
I'm sure it is a hairy problem for some combination of languages/tools but I guess I'm somehow completely side stepping it. Perhaps I'm more likely to encounter it if I treated my laptop as a server because that seems more like where Nix might shine as a sort of ansible/chef/puppet on steroids ;)