Lol! Even if it was made of solid lead it would be fine for potable water as long as the water is not hot or acidic.
My well water IS quite acidic. Had to replace all my copper piping due to pinholes, thousands in water damage when one became a real pisser behind the paneling in a corner up under the stairwell. Was wondering why the room had become somewhat damp for a couple of years previously. Walked in one day to find basement soaked. And yes, the ancient Romans probably did hurt themselves by adding white lead to their wine to sweeten it.
And everyone these days has hot water!