Pros
I have worked at several databases/tech companies, and will say Cockroach has very good culture, good leadership, and very good people . They pay also pay well, have excellent onboarding, training etc.
Cons
Acquiring customers and growing is a challenge. The Distributed SQL value proposition of CockroachDB only seems to resonate with the most sophisticated "tech native" companies, and in a relatively narrow band of use-cases. Penetrating the broader corporate market is a challenge. While the technology is very cool and best-in-class for distributed SQL (one could say "a better mousetrap"), its not compelling enough to replace Postgres, Oracle, and other cloud SQL databases. Database platforms are very sticky! There is no cost/price advantage either, so need a true "burning platform" use case is required to get prospects to consider CockroachDB.