Why is profuse sweating on a hot day good and yet a potential problem?

Good because the sweat and evaporating of the sweat causes cooling of the body. Bad because excessive water and salt loss may occur. Fluid and electrolyte imbalances may follow.