I'm much less worried about storage hardware failures than other parts of the process scribbling over memory that sqlite has mapped. Being able to detect incorrect software behavior, regardless of the source, is useful in its own right.