I think you missed the point of the psst.
You want to provide a proper day and night cycle. The OP is asking about lighting the cage at night. If you put a white light at night it would cause your snakes to stress. The day/night cycle can really become important if you are a breeder.
As far as your red light messing with your eyes. Does it have UV properties to it? Or is the light in a position that you are seeing directly into the bulb?
The red and blue for that matter should not effect your eyes, that's why they are used when you need to preserve your nightvision.