Night Photography with a Sony Digital Mavica!

How is the Sony Digital Mavica FD-91 as a night photography camera in 2024? It's easy to dismiss this 90s camera with it's meager 0.7 megapixels as merely a toy today. However, it was meant as a serious camera when it was released and I try to use it like any camera. Of course you have to take the low resolution in mind which means you have to quite adaptive when using it!