My understanding is that those are usually for wastewater applications, pipes that aren't under high pressure, like you said. Also this is just speculation but the chemistry of the water put out by drinking water plants is specifically suited to be non corrosive to lead, copper, galvanized steel, other metals, and pvc piping. I'm familiar with the liners you're talking about but I'm not sure if they'd meet health code standards for drinking water pipes due to chemical exchange between the material and water.

Those videos are satisfying to watch tho lol.