Hopefully someone can explain how this relay works?

They are simply switching the ground side of the relay instead of the hot side. Common when using an ecu to control a relay. So you’ll have two constant hots, a trigger side and a load side. Then a load, and a switched ground.