Turso is sqlite not postgresql
Is this faster / more resilient?
With Neon you get a postgresql database over a postgres wire format connection.
So if you have an already existing app speaking postgres to a database somewhere, Neon is a drop-in-replacement, while Turso would require adapting to their custom API.
If you are creating a new service, you might need/want to take advantage of e.g postgres extensions [0] for storing geographical data or pg_vector for similarity searches etc. Or you simply need more stringent serialisability promises than what libsql / turso can provide.
But if you just writing something new from scratch and have "simple" demands, I think something like Turso looks cool (and cheap!).
I guess it's just trust. I trust postgres more than I trust sqlite for building big apps.
One last point: I'd look at feature set of both offerings. I suspect the features of the postgres offering to be more conducive to scale.
Take some time to learn about the differences between postgres and sqlite it is good to know about the trade offs.