no one will be able to tell you how long it take to corrode through. the pipe also may leak before corroding through if it is structurally stressed and the corrosion just weakens it enough.
the difference between schedule 40 and 80 is more thickness, which gives you more time to reach that point. but more important is how you treat your water and what environment it is in. Run a lot of hot saltwater with a lot of oxygen through the pipe and embed it in a low pH environment and you see what I mean.
Like car sold in California won't rust in 30 years... take the same car to the rust belt and it will show rust after 10 years or sooner.