Are Water exercises often painful because of high impact?

No, as water is cushioning your every move once in the water.

Diving can be painful if you hit the water wrong.