This Light effect not showing in Render but shows up in View-port rendering. Affecting both EEVEE and Cycles
The final result is hard to see because there is no texture in the shared file and all is pink.
Though, it seems some of the lamps are not activated for rendering.

To see this icon, use the filter button:

There is 3 levels of visibility:

The eye icon that corresponds to H and AltH

Enable/disable in viewports, the monitor icon

Enable/disable in renders, the camera icon


These last two also correspond to the object properties here: