I'd look at this:
1.5" ID 70 psi Braided Flexible Chemical Resistant PVC Tubing
instead.

Flex PVC, like you found at Lowes varies a lot in quality, and I have never discovered how to tell the good stuff (rare) from the junk (common). The typical stuff, which I've purchased from SCP wholesale supply, gets pinholes after a year or so.

The reinforced flex is made for insert fittings and clamps, but can be glued if you are very careful. It tends to not maintain a perfectly round cross-section, so you have to be careful when you insert it.

Maybe you and Brokk can work out a 'works-for-everybody' method of plumbing to Intex-type pools?