The Night mode is just using long exposure - if you have steady hands or a tripod and a still subject you can get a decent picture.
If you're using the camera indoors in auto mode with 500-1000 lumen lighting - the pictures are very dim.
See attachment with low light pictures of a newspaper...