Well, if this idea is so glorious, why is none of the large array of water harvesting devices that pop up multiple times a year ever deployed at scale?

Easy answer: because they are all marketing bullshit that doesn't solve the actual problem and instead only exists to part investors from their cash.