I don't think Cockroachdb is a better choice but it's fine, most games tend to use MySQL / PG from my experience. Reasons:

- MySQL / PG are proven solution

- Your game will not outscale a single instance

- Developpers know SQL

- Mature C++/C# drivers