The hand can't attack, activate magic items, or carry more than 10
pounds.
The rules are particular, it says it can carry up to 10 lbs, not that it can exert 10 lbs of force. Your example seems to assume that the hand would be, for example, grasping an object and 'pulling' you toward itself against the weight of the object. This will not work, since the hand is not tethered to anything, and you are over 10 lbs.
The closest you could get is having it press against your body and attempt to move you, but this will also not work (you are over 10lbs), nor will it exert force (the descriptions says nothing about exerting force)
Your best bet would be to have it carry one end of a rope while you carry the other, and have it tie that rope to something, then pull yourself along the rope. (The hand will not be able to tug you along).
Or you could shrink yourself down until you're less than 10 lbs as in this question Using Mage Hand to fly?