Slide a hand gently into a pool and the water moves out of the way. Hit the surface flat and fast, and moving that water requires much more force.
Your body pushes water into motion; the water pushes back, rapidly slowing your body. That sharp force is what makes a belly flop hurt.
The water has not turned solid. You have demanded a sudden movement from a large patch of it.