When I asked Google, can night shot be turned off forever on pixel, Gemini said this...
Yes, on a Pixel phone, you can turn off "Night Sight" (also called "Night Shot") permanently by disabling the "Auto Night Sight" feature in the camera settings, which means the phone will no longer automatically activate Night Sight in low-light situations; you can manually turn it on when needed, but it won't switch on by itself. [1, 2, 3]
How to do it: [1, 2, 4]
Open the Camera app, Access the camera settings, Find the "Night Sight" option, and Toggle the "Auto Night Sight" setting to off. [1, 2, 3, 4]
Key points to remember: [1, 2, 3]
• This feature is available on most recent Pixel phones. [1, 2, 3]
• Turning off "Auto Night Sight" allows you to fully control when Night Sight is used. [1, 2, 3]
• If you want to use Night Sight in a specific situation, you can still manually turn it on through the camera settings. [1, 2, 4]
Now you don't say specifically which pixel you have but this doesn't say starting with the... Or beginning in... Sooooo, maybe.
When I started typing it it did show several specific models, like the question had been asked before probably by a few who got specific, and that could have different instructions.
Just glancing over the instructions it kinda looked like you're already looking in this area so let us know what you find and include your exact device.