However, Aurora DSQL is trying to compete with both CDB and Spanner, and they explicitly promise snapshot isolation.
But this test wasn't of Aurora DSQL
Cockroach doesn't offer strict serializability. It has serializability with some limits depending on clock drift. Also CockroachDB does not provide linearizability over the entire database.