With proper monitoring and a well maintained internal corrosion control and external threat control systems you can stretch out the timeline for non "acts of god" (ie natural disasters, terrorist attacks, etc) to greater than the life of the structure. The methods for internal and external control are well understood and practiced to varying degrees of effectiveness.
Elimination of the hazards is impractical, so minimization of risk exposure and frequency is the best that can practically be done.
All the hubbub about stopping new pipeline construction means that more incident prone methods are used - be it trucking, rail transportation, or use of 50+ year old pipelines. The new lines are better engineered, understood, and have more stringent operational controls in place. I've worked on pipelines from the 1940's that are still safely operated, and lines from the 2010's that have already self excavated. These things can be controlled with the right engineering, organizational, and governmental oversight.