There's nothing whatsoever to do with surface tension, which is utterly minimal.
The actual reason water is so hard is simply that the water need to move out of your way when you fall into it, and if you are moving faster than it can do that then you simply hit the water as if it were a solid.
Both bubbles and waves make it easier for the water to move out of your way.