Something that connects the mains ac to the house plumbing through this device would seem like a winner, since you can pass enormous amounts of electricity through water filled 22mm pipe, and the resistance would be low. ...
To the post ages ago about cows near a tree being killed, the bbc reported on it a while ago. They thought the large puddle they were all standing in was the cause, all the cows under the tree were killed not just one.
The same earthing for 230 volt safety must be better for surges. Conductivity, in this case, is not about resistance (lower resistance is a thicker wire). The critical parameter is impedance (lower impedance is a shorter wire). Pipes have solder joints, sharp bends, etc. Factors that contribute to excessive impedance.
The important parameters for better earthing include short ('less than 3 meters'), no sharp bends, no splices, not inside metallic conduit, all ground wires route separate till each meets at the single point ground, and ground wires separate from other non-grounding wires.
Wire impedance is also why a protector is better located close to earth AND farther from the appliance. That 15 meters between the protector and appliance or that up to 50 meter separation used in a BT CO enhance protection.
If the water pipe is solid copper that enters the building adjacent to other utilities, then the water pipe is a good earth ground for surge protection. But only if that ground is also permitted by local human safety codes.
The 'cows' example has existed for generations. A recent event would only be a repeat of what happens often. Another example is sleeping campers. Those sleeping pointed as the struck tree were hurt. Those sleeping tangent to the tree were not a 'better conductor to distant charges'; therefore did no suffer electric shock from a lightning bolt that struck the tree.
Same applied to a house with good earthing at the service entrance. Unknown was a vein of graphite (better conductive earth) on the other side of that house. A surge entered on AC mains, ignored the service entrance ground, and passed through the house to obtain earth on the building's far side. Solution was to encircle the home with a buried ground loop wire. Better earthing meant a surge current did not enter the house to obtain better earth ground.
Damage is how one discovers a flaw to correct it. Unfortunately, few tests to find human 'surge protection' mistakes. The first test is when a surge occurs. If a surge protection system is properly installed, then nobody knows the test has occurred and the system has passed. Best we can do is learn the principles and avoid previous mistakes by others.
First and foremost is to be almost religious about the earthing since every protector is only as effective as its earth ground.