EdStainless: we're not disagreeing. I will always choose corrosion immunity over corrosion resistance. Trying to find a metallic alloy for this service is foolhardy in my opinion.
The correct selection between the two options (FRP and lined metallic piping) depends on a great many factors the OP hasn't listed. Yes, lined metallic piping suffers from the vulnerability you've indicated, amongst others, but FRP piping is not without its pitfalls as well- especially at small linesizes (i.e. 1.5" and 2"). Just as you've seen liner failures leading to rapid loss of containment, I've seen Smith Fibrecast fittings which leak at several hundred locations right out of the box, and carefully assembled and fully cured socket-welded FRP pipe spools which exhibited 90% joint leakage during a hydrotest. Properly designed, tested, installed and monitored/ maintained, both systems can be fit for purpose.