Because kernel devs are not able to answer that. It is beyond kernel control as SSDs are backed by nested operating systems under the hood with own bugs and non-determinism.
I don't agree these factors should be hidden, unless the API guarantees every single operation is atomic & durable.
Full details as to atomicity & durability need be available to callers (not just SQLite, but any application that wants to provide a reliable datastore) so that they can write information durably including across coordinated multi-file data structures.
Then they could at least say "we're doing everything we can; next time you buy a storage device look for feature X".