The improved Night Sight on the Pixel 6 line allows users to select a faster exposure time or a longer exposure time for Night Sight
With the Night Sight tab pressed, tapping the button on the lower right side of the screen will allow you to select between a 1, 2, or 3 second exposure time or Max which usually goes up to 6 seconds depending on the lighting conditions. So it is up to you whether you want a faster exposure time or a longer exposure time for better image quality. Either way, the exposure time will be much shorter for Pixel 6 and Pixel 6 Pro users than what they had to deal with the first-gen Night Sight.
This means that a Pixel 6 series user taking a photo using Night Sight won’t have to try and hold the camera steady as long as they used to in order to take a sharp Night Sight photo.
This writer’s Pixel 6 Pro is running QPR3 Beta 1 and the version of the Google Camera app on my phone is version 8.8. To check which version of the app you have, go to Settings > Apps and tap on See all xxx apps. Scroll down to the Camera app and at the very bottom of the page it will show you which version of the Google Camera app you have.