Tension is a force.
If I’m hanging from a rope, tension is the force in that rope that is sufficient to balance out the “mg” which is my mass and the gravitational attraction of Earth which is trying to pull me down and the rope is preventing that from happening.
If you hang on to the tope, the rope will provide through tension, whatever force is needed to prevent you from falling, up to the point where there’s so much force that it destroys the rope.