Putting in in simpler terms, whenever there is a fault, of any kind (ground fault, line-to-line, three-phase, etc.) there will be a large amount of current flowing through the fault point. That current comes mostly from the source (for the moment, let's ignore the additional contribution from any large motors that happened to be running at the time). The current has to flow through every breaker that is in line from the service point to the fault point. Every one of those breakers is going to be given the command to open. One will win the race. Why should you expect it not to be the main breaker?
It takes some clever design choices, including breaker selection and breaker trip settings, to ensure that the only breaker that can win the race is the one that is closest to the fault point. It is only in a very limited set of circumstances that the NEC requires us to include coordination as a design consideration. So in a high percentage of facilities, a fault in a light fixture may very well take out the main breaker, if the fault current is high enough.