Well, for me, it doesn't make sense. It should not be called Waterfall if the intention is to climb a waterfall. It should be Water Fountain or similar terms. Anyway, I just noticed that in every generation(except for Gen 5), it all looks like water fountain to me.
Basically.
But they ran with it ever since. The Japanese name is actually Waterfall Climb, so it makes more sense in that language.