Something similar happened in the Haskell community, where some people called for Anduril job postings to be removed.
Nix is a software project, not a social movement. The goals of Nix are entirely separate from how the software is used.
I really like Coinbase's statement that is is mission focused (https://www.coinbase.com/en-ca/blog/coinbase-is-a-mission-fo...). Anything that isn't directly related to its mission is out-of-scope. I wish the same was true about software projects like Nix.
If you care about the way your software is used, then by all means, say it in the license! Of course, such software won't get used much.
The author talks about the productivity losses rising from social-issue disagreement in the workplace, but it's rare that you can point to a press release from a C-suite employee and say "this specific document caused one in twenty staff members to leave immediately". The productivity destruction at Coinbase from that press release was enormous.
https://www.coinbase.com/en-gb/blog/a-follow-up-to-coinbase-...
Having a narrow mission focus is the only way to retain your actual best staff.