Earlier quoted context omitted.
It depends strongly on implementation. LEDs can produce white light at any color temperature and CRIs ranging from terrible to great. Quality LEDs are quite nice indeed (when they're not turning purple). Most LED streetlights replaced sodium vapor lights, though, which produce the sickliest, most horrible orange color known to humanity. Just about any LED is an improvement over those.
Sodium lights aren’t even orange in the normal sense of the word. They only emit one wavelength.
It's hard to think of a more normal sense of the word "orange" than "emitting and/or reflecting predominantly wavelengths between 590 and 620 nm." I guess you could argue that sodium is close enough to that lower edge to be yellow?