My understanding is that light directly above is their method of determining how to stay upright, so artificial lights cause them to think up is towards the light, so attempting to go in a straight line puts them in orbit around it.

They aren’t trying to go towards the light at all. They’re attempting to go perpendicular to the light.