I guess they pick up water through their roots. It may not rain often, but when it does a cactus picks up water and stores it in its thick stems.

afaik storing water when it rains and expelling much less water when they breath. citation: my gr 12 bio class. Which i finished 20 years ago, so my memory could be rusty