I don’t have an academic citation handy. However…
I was in Rome a few weeks ago. During the visit, I arranged a tour of the Ostia Antica site, guided by a professional archeologist. This location was settled very early, with some evidence suggesting permanent residency in the 7th century BCE; since it was at the original mouth of the Tiber, it was useful for many reasons over several centuries. It wasn’t really developed into a fully proper Roman city, however, until after 100 CE. It went into decline after the Fall of Rome, and then was almost fully abandoned by everyone except local fishing communities after flooding caused a major shift in the course of the Tiber, which accounts for the site’s relatively good state of preservation, largely frozen at the point of its abandonment. Consequently, there’s layers and layers of history on view.
We saw two things that are of interest for this question.
One: the two major surviving bathhouses are damaged in such a way that the plumbing inside the walls is visible. These pipes are made of terra cotta (very clever technology, warming your bathhouse by bringing heat directly up inside the walls); the partially-fallen structures expose the walls’ innards in cross section. One of the two facilities (the “Neptune” bathhouse, with the famously well preserved floor mosaics) was built and then remodeled in the 300s. The other bathhouse was originally built earlier, but then torn down and a larger one built in its place sometime before 400 CE. So by that point, terra cotta plumbing seems to be the standard.
More interesting is a recently excavated storehouse. Entry isn’t allowed, but you can look inside from the exterior gate. The floor of the storehouse is covered with hundreds of lead pipes, dirty and bent and broken. The evidence is not definitive by any means, but the archeologist said the current interpretation is that, based on their used and damaged condition, these were previously installed, and then were ripped out for replacement and dumped here.
The archeologist did note that while the Romans were vaguely aware of the connection between lead and health issues, they didn’t begin to fully turn away from the metal until very late. It was just too cheap and readily available (it was a by-product from silver mining) and useful for large-scale applications due to its easy workability. The upper-class greatly preferred the more expensive clay pipes because of the health concerns, but lead was left in place in the poorer neighborhoods for a long time.
So it’s possible that the evidence at Ostia Antica shows a snapshot somewhere in this transition. As the city became wealthier and more people could afford to remodel their houses, the old lead plumbing would be torn out and clay replacements installed. Or this could be left over from one of the rebuilt bathhouses. And then, because the Romans essentially abandoned the city in the middle of all this, we get to see them in the process of changing their minds.
Edit to add: ninja’d on the academic citation.