There’s a Thread in the SDK Forum around these issues. There is a link to some older night shots from the Alpha / Beta period in this thread or another where it shows how different it was as you see in that video …
The best thing you can do is file bugs. That will raise its visibility.
https://forums.flightsimulator.com/t/dev-night-light/130529/27
https://forums.flightsimulator.com/t/what-happened-to-the-night-lighting/169018/63