It is ACID if you add all the query flags to say you want that. The majority of users don't, because it costs performance, which is in many / most? applications more important than correctness.