The protection system known as TPWS is widely fitted on the UK network. This cannot always prevent a SPAD, but is designed to stop a train from reaching a conflict point in a junction in the event of an actual or anticipated SPAD. In the case of sidings, exit signals are not usually fitted with TPWS equipment but the track connections have always been equipped with 'trap points' or derailler devices which operate together with the junction points where the siding joins the main line. If a train attempts to exit a siding without a clear signal and route set it should be derailed before it reaches any conflict point, which is exactly what has occurred at Sheffield in this case. Once such a derailment has occurred, other movements in the area are often prevented due to track, signalling equipment and associated cabling damage, and the trap points are invariably fitted with an 'interrupter' device that is triggered by the derailing train to deliberately places the track circuits in the vicinity to occupied status and hence prevent any further train movement until the situation has been assessed, debris cleared and equipment restored to normal service.
I am reminded of the incident outside Paddington in the recentish past where a Turbo was derailed into an OHLE gantry. Did it’s job similarly if not dramatically!