Not a big fan of the US market's ongoing obsession with mimicking incandescent spectrum myself, but impact of excess blue on circadian rhythm is very real. And while this can be mitigated to a degree with directing the light where it's needed - downward - there's still lingering effect. In areas with wildlife the impact on native creatures can be quite pronounced: used to be a metal halide streetlight in front of a prior family home across the street from a tree that blue jays nested in and they would scream all night because of that streetlight.
Suspect that pretty much any reasonable CCT white LED will be a huge step up over sodium lamps' destruction of visual cognition.
There's actually one way around that-use high CRI for streetlights. Look at the spectra of very high CRI LEDs of any CCT. There is no pronounced blue spike. So for any given lux level you reduce the amount of blue light substantially.
Based on my anecdotal observations, another benefit of high CRI lighting is that the apparent brightness is higher for any given lux level. Or put another way, you can negate the lower efficiency of high CRI lighting by lighting to lower levels, still using roughly the same power as before, while not sacrificing apparent brightness.
The final issue has to do with peripheral vision. All other things being equal (i.e. CRI, lux), higher CCT (up to maybe 5000K) results in better peripheral vision. If you use a lower CCT light, you have to increase the lux to have the same level of peripheral vision. And doing so probably gives you at least the same amount of blue light as the higher CCT solution, perhaps even more. Or put more succinctly, the only way you can get away with reducing blue light content is by sacrificing safety due to reduced peripheral vision (assuming similar CRIs for both high and low CCTs). Using low CCT LEDs to supposedly solve the blue light issue then isn't a viable solution.
However, you can reduce blue light without sacrificing peripheral vision by going to very high CRIs. Strangely, it's almost dogma for outdoor lighting that CRI 70 or so is "good enough". Higher CRIs (95 or better) not only makes everything look better, but it reduces the blue spike, and lets you lower lux levels also.