Cameras are designed to capture & store the light in a way we can interpret later. They intentionally weren’t designed to edit or interpret the light and make corrections.
Smart phones automatically do interpret and “correct” images. This can lead to artificially created artifacts in the image files. Professional photographers will often prefer the raw because they can apply their own edits without said artifacts.
Now sure, camera photos are good for 99% of people, 99% of the time. BUT because the software on cameras were never designed to do those corrections, they just don’t. This makes night images worse, unless you decrease shutter speed.
On a side note, it’s this very fact that I find it difficult to accept cell phone footage as video evidence. Particularly, if you’re looking at fine detail, as the filters often modify / generate the fine detail.