The lights don't draw anything worth switching off for. It's not possible to drain the 12V that way, first because the lights draw so little, and second because the traction battery keeps the 12V topped up anyway. The OPs problem was nothing to do with the lights, that was coincidence. His 12V had a loose connection.
It would be nice to be able to switch the lights off while the car is still on, so that one could sit in the car with the heating and stereo on but not showing lights (drive-in cinema was a case someone mentioned, also aurora-watching and camping), but the amount of electricity they consume is neither here nor there.
I did the tour of the Ardnamurchan lighthouse last week. It has been fitted out with LED lights to replace - well, the whale oil then the paraffin then the incandescent bulbs or whatever has been used to light it over the decades - and now you couldn't boil a kettle on what that structure consumes.