I used to have those bendable lights on the industrial machines and the darn things would never stay in place. Too much vibration I guess.
The pole that you linked to looks nice but I have carpet on my sewing room and roller coasters just don’t get along too well.
If the light proves too tippy I will get the hubby to make me something better/wider base. We will see how this pans out.