Cassandra5 is going to fully support ACID by using Accord protocol(leaderless consensus algorithm).

Youtube - Cassandra5 ACID

Blog - Cassandra5 ACID

Datanami - Cassandra5 ACID