We of course can make LEDs of more or less any color. The current white LEDs are high-power blue LEDs that are covered by various phosphors to give a mix of colors for "full spectrum" illumination. Different color temperatures are produced by different mixes of phosphors. This is pretty similar to how the traditional luminescent (mercury vapor-based) lamps worked.

But different phosphors have different efficiency and price. LED lamps were first introduced for interior lighting, where sun-like spectrum is welcome. Such LEDs were produced en masse and relatively cheaply. So street lighting naturally used them, because municipalities usually look for the cheapest viable option.

We likely could produce high-power narrow-spectrum orange LEDs if there was a large market for the economies of scale to kick in. You can buy deep orange LED lamps today (look for color temperature 1800K or 1600K, "amber"), but they are more expensive, because they are niche.

Modern street lighting provides a way clearer view of the scene imo than the old sodium lighting. Maybe it's just brighter now.