Most people have it set up where there is only 1 pump which is the return in the sump. The water overflowing is caused by water being pumped back into the main tank. Therefore if the pump stops (burns up, lights go out whatever) a little more will flow back down to the sump, then it just stops.
Does that make sense?
Its like taking a pitcher of water and puring into a bowl, once it starts flowing over if you stop pouring it stops flowing over.