https://www.cnet.com/news/pixel-3-photos-drastically-improve-with-the-new-night-mode/

We, however, installed the modified camera app on the Pixel 3 XL to show you a little of what to expect from the Night Sight mode once it's officially released.

Keep in mind that this may change a bit once it is officially available, but the improvements we noticed in our tests are remarkable -- we could almost say the difference is night and day (literally) from how the camera behaved previously.