Im not a physics prof or anything, and Im mostly using my imagination and a stick to work this out, but i think the reason is:
the greater the distance from the pivot the greater the radius of the circle traced by the handle of the wrench around the pivot, and therefore the greater the perimiter of that circle (pi x 2r).
This means that for the same rotation of the pivot, the handle of a long wrench will have to travel a greater distance, than that of a short wrench. Ok, so this must also work in the reverse, a distance travelled by the handle of a long wrench will cause the pivot to rotate less than if the same distance were traveled by the handle of a short wrench. (think of the distances as the perimiters of the imaginary circles the handles of these wrenches travel around the pivot or screw as it rotates.)
This must mean that by using a longer wrench we can divide the force needed to rotate the pivot into smaller parts: since it takes less force to rotate the pivot less (by a smaller angle), we can apply a smaller force to the handle of the wrench while still making it spin around the pivot, wheras if we were to use a shorter wrench making the handle of that wrench travel the same distance around the pivot would cause the pivot itself to spin more and would therefore require a higher force.
Ok, so, if im right, this means that by applying a smaller force (albiet over a longer period of time: since the handle of the wrench must travel a longer distance) to a longer wrench we can rotate the pivot which would have taken a much greater force to rotate with a shorter wrench.
think of this principle applied to a car. the car doesnt have to use all its engine power to travel somewhere. can use minimum engine power and travell very slowly. in the end it will reach its destination.
so anyways, i hope im right and i hpe this helped.