Well, after being unofficially available via a modified Camera app for a few weeks it seems that Google is ready to flick the switch to begin rolling Night Sight out with the 3rd-generation Pixels the first to benefit.
If you're only shopping for yourself or a loved one, then you'll have to wait until November 22nd to order a discounted Pixel 3 from Google. 100GB data | £48 per month This deal really is full of bonuses - not only do you get the Pixel 3 but you also get a Google Home Mini and a whopping 100GB of data! While soon after the announcement, we saw people tearing apart the Pixel 3 Google Camera APK to get the feature which was still in beta, today the company is rolling it out officially. Text on signs is clearer, the overall image is much less grainy, and you can even make out each individual brick in the building no matter where you're looking. "Night Sight is exactly what the Pixel 3 needed to really round out its photo toolkit". Even Night Sight has its limits, though. However, the processing technology behind Night Sight is not dependent on the latest hardware. As while the software will look to offset against user and target movement, the more still the user and target remains during the process, the greater the results that can be expected. Night Sight will also appear when the phone detects that you're taking pictures in low-light conditions and a pop-up will appear right above the shutter button so you do not have to manually turn them on every time.
Night Sight is a prime example of where Google is going with its Pixel line in general. You can read in detail about the working of Night Sight on Google's blog. You'll find it in the Pixel camera app under the "More" section.