Streetlights aren't for doing your makeup, they're for seeing hazards in the roadway that are beyond the range of a vehicle's headlights. Orange is the ideal color for outdoor lighting, because of the way the light-sensitive proteins in our eyes are 'tuned' ('cones' and 'rods', 'photopic' to 'mesopic' and 'scotopic', etc). My notes from a few years ago: https://teslabox.com/2020/01/color-vision-night-vision-notes... - tl/dr: peripheral vision is tuned to blue, 2 of the 3 color-sensitive proteins are highly sensitive to orange light.
Curious: why did you link to that particular thread? 66 comments, including one by yours truly. imho, this is the best of that thread: https://news.ycombinator.com/item?id=19855545