That's essentially correct, but modern tech also makes it relatively easy (and in the end cheaper compared to non-LED) to

- make lights with a properly focused well directed beam instead of flooding the whole place; we have a new one close to our house and it sheds light only on the street itself to the point you can almost see a nice straight line where the light beam stops and beyond that line it's markedly darker than it used to be even though the light beam itself has a higher intensity

- make lights which emit in wavelengths which are less environmentally harmful for flora/fauna

- make each lantern remote controllable (on/off/dimming); main street lights here dim after 11pm and are truned off in all secondary streets

(there's a website dedcated to listing the best models for all of this but I cannot find it anymore)

The thing which is lacking here mostly is awareness and governments willing to implement this properly. We live in a rather small rural village which did implement all of this - too bad there's no research project assesing before and after but since it counters most of the negatives I assume it should turn out positive for the environment. Birds are definitely positively affected by it: execpt for owls I don't hear any singing in the middle of the night anymore. And in any case it feels pretty 'normal' to come home at night while it's properly dark.