Water quality is key for long-life. Copper could last a century, or deteriorate in a decade if it's not good. I'd probably budget for a repipe with pex or cpvc which wouldn't be affected by the slightly acidic water. I'd also chat up a bunch of neighbors to see what their experiences are along with asking a few plumbers and maybe the local building inspector for their thoughts and experiences.
There are some workmanship practices that could cause premature failures, as could a bad batch of piping. Turbulance and failing to ream out the pipe after cutting can cause pinholes downstream from a fitting. Excessive pressure makes things worse. Excessive use of acid flux might have degraded the piping shortly after installation, but would long since have washed away. I'd be more worried if the pinholes occured in the middle of a long run, away from any fitting (the turbulance from a poorly done fitting may occur within say the next foot or so before it returns to normal depending on the flow rate).