This blend mode simply replaces the pixel values of the light over the underlying lights.
It uses the alpha on the light for transparent areas.
It's a great way to add non-transparent (solid) content onto the HDRI map.
Over is the default blend mode for image based Preset lights, Picture Lights and Sky Background.
The people and lights have been added to this HDRI map using Over blend mode.