Sqlite is the wrong layer at which to care about storage hardware failures. That would be the job of the disks themselves, the hardware or software volume manager, or filesystem.
A couple of my friends who work in the financial domain showed surprise at this post - they had no idea this was possible. I guess most people just assume databases 'just work'?
SQLite isn’t doing anything wrong here, IMO — people who use non-ECC ran for critical workloads are.
But people do wrong things all the time, so it doesn’t surprise me.