What happens when the rear differential stops working in a SUV?

It will stop moving. If it is an emergency, turn on the transfer case if it is so equipped, and you can drive to your destination in front wheel drive only. This will only work if the rear end still moves freely and has not locked up.