I have holes in both my Thermarest Neo Air pads. It has been easy to find the holes and patch them. To me the comfort is worth it, just like I'd rather deal with the occasional tube/tubeless puncture than ride solid tires.
I tried one backpacking trip with a closed cell pad and vowed never again to make that mistake