Yes, the point of support (i.e. the pivot) needs to be strong enough to withstand the weight of the earth and the force used to raise the earth (i.e. the effort).
This is simply a matter of balance of forces. The reation at the pivot equals to the weight of the earth and the effort.