To this day only Oracle RAC provides true active-active cluster. All the other things are not real clusters, just replications.
Also, Cassandra is active-active as well.
I'm sure there are others, but I'm less familiar with them (Yugabyte, Couchbase, etc..)
So it's not consistent in the CAP Theorem sense. Comparing it with other databases that don't lose writes and don't have split brain issues makes no sense
Of course, the issue with all shared-storage systems is how much it costs to have a reliable and fast shared storage.