My guess is yes, it might be a little grainy but if you cranked the exposure to 10 seconds, you would have likely gotten a usable shot.
As a reference, here is one pic that I just took of my closet with and without night mode. There is a little bit of light coming from two rooms away and I can barely make out any colors with my eyes. One was shot with exposure = 0 seconds, the other shot with 9 seconds.