A very heavy tripod is used to make the camera / tripod system more massive i.e. increase the inertia. With more mass the system is less likely to vibrate or be affected by things like a slight wind outside. Less vibration will lead to a clearer picture.