Lead pipes are common in OLD houses but even there lead pipes are only
used for drainage and not for incoming water. I don't think lead pipes have
been used for incoming water for AT LEAST 150 years.
Maybe not in the States, but this house, built about 70 years ago, still
has lead water pipes. Admittedly not for drinking water, but for some of
the distribution system from the water tank in the loft (roof space).
We replace it when it gives trouble, and use the lead pipe to make
weights (seriously!)
-tony