I have seen how it works great in a team, if all are onboard.
No place I've worked at was interested in the advantages of Nix though.
I wonder if switching to something less recognizable to a functional programming language might help adoption.
The approach Starlark (the DSL for Bazel) has taken, is have mutable datastructures, but freeze them after they are evaluated. This seems a lot more explainable and debuggable for the average programmer.
Infinite recursion errors are not fun to debug in Nixlang.
At my current job, NX is used to be a kind of Nix, but it does not seem to try to solve the entire problem space. Just to solve the additional complexity that introducing a monorepo in regards to tracking build dependencies.
It seems to me that how awesome Nix is from a tech perspective, it doesn't make delivering actual software any easier without team buy-in and effort in integrating in their delivery pipelines.