Them old houses were supplied by a grounded system. Not having an electrode connection at the house doesn't make the system ungrounded. So those metal water pipes were still electrically continuous to the underground supply pipe and therefore still have full voltage between ungrounded conductors and those grounded pipes.
If you had a true ungrounded system, the first fault to water pipe ends up creating an unintended grounded conductor out of that conductor but there is no shock hazard other than to other ungrounded conductors.
I have run into issues a few times with old metallic sewer lines causing mild shocks, usually in bath tubs or showers. Problem is almost no one bonded the sewer piping, so it is at true earth potential. The water piping is bonded to service neutral, but any voltage drop imposed on S/N will exist between the water faucet(s) and the metal tub drain. Might only be 2-3 volts but standing in the water and touch the water faucet or even water spout and you get hammered by it. Running a bonding jumper between water piping and sewer piping solved the problem every time.