Your weight pushing you up in the water is a function of buoyancy and density which are caused by motion.
Buoyancy always goes in the direction of the motion, which shows we have an upward vector and not a downward vector (gravity).
You can test this for yourself using your phone's accelerometer (verify, don't trust)