Lol, is that a joke.
Seesh.
[To be clear, i think sqlite is the hands down winner on this front, no contest. Does the Turso test suite qualify it to be used in safety critical applications? I don't think so].
To your other points - look if it works for you i'm not here to tell you you can't use it. However these features sound more trendy than useful. To me these sound like negatives. A bunch of extra features not related to being a relational database suggests they aren't concentrating on the core product. I dont know enough about their model for async & concurrent writes to really evaluate the cost/benefit, but both those features sound potentially really scary and of questionable value.
At the end of the day its just not a compelling pitch. It seems like trading reliability and stability for a bunch of meaningless bling.
Best of luck to them, but at this point yeah, sqlite sounds like a much better option to me.