https://www.cnet.com/news/night-sight-on-the-pixel-3-makes-an-incredible-difference-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.