Why is a 'short-circuit'in a mains circuit dangerous?

It is potentially dangerous because it provides a low-resistance path across the supply voltage. That causes excessive current to flow, and if all is well a fuse or circuit-breaker will operate to shut off the supply. Without that there might be enough current to cause a fire.