So the simple event of a plastic pipe pushing out of a compression fitting after 20 years and going undetected for a few hours results in weeks of recovery work and possibly $10-15k out of pocket expense.

These are the moment of home ownership that are frustrating. Thankfully I had been saving for new carpet/flooring and kitchen upgrade in a few years, but now that money will necessarily disappear to something literally unseen under the house which is hugely disappointing :(