Welcome to fucking software. I updated Mac OS X one time (or maybe it was just iTunes) and it deleted my home directory (remember that one)? I didn't open the mail promptly and missed the recall notice that my car's antilock brakes had a failure mode that was catastrophic in snow, and then I drove in the snow and then couldn't stop the car. I flew on this new model of Boeing jet a couple years ago, and it had a bug and crashed and I died.
OK, one of those is not true but this is how ALL software of any complexity is. I'm also old and ornery like the OP and I don't like it and if I get drunk I will talk hella shit about it but it's just a fact.
Software sucks. There was indeed a time when we (collectively) did a lot more to try to prove it worked before shipping it. But then:
a.) the money people realized it made money if it mostly worked, and made less money if we went all formal-proofy on it
b.) the software people realized that all the specs and architecture documents and fuzz testing and automated semantic analysis and literal actual voodoo dolls all did totally help, BUT...
(you know, they help ... BUT probably wouldn't have helped in this case, or lots of other cases...)
So this is just the way software is in almost every walk of life. ZFS is amazing, one of the most life-improving software technologies for me; up there with antibiotics, and UTF-8.
Yes, they had a pretty amazing bug, too. So yeah, "... at least for now, there's simply no way to reliably detect bit rot and other data integrity issues and be assured they can be remedied."
Which is just like it ALWAYS HAS BEEN and ALWAYS WILL BE.
But in the fullness of time, so far, ZFS has gotten us closer than anything else to that (impossible, unacheivable) ideal.