The majority of open source projects need to be usable without installing proprietary dependencies. Whatever you might think of CockroachDB's choice, this means that any other project depending on them makes their users deal with that license too, and while CockroachDB might be willing to push that on their users, that doesn't mean other projects want to follow them down that path and lose their users in the process.
Leaving aside any license compatibility issues, an open source project with a proprietary dependency will lose users compared to an open source project with entirely open dependencies. This also causes problems for some Linux distributions.