I've never been snow skiing. And I've only attempted to water ski once. It didn't end well.
Knowing all that, if you asked me which one is a better experience or what they are like, I probably wouldn't be able to offer any valuable insight. I'd probably say something like "I don't know. I've never been snow skiing, and water skiing was one of the least enjoyable moments of my life, so I'm probably the wrong person to ask." The last thing I would do is pull an answer from my ass and comment on two things I know nothing about.