The longer exposure doesn’t seem to affect other aspects of the night sky though, I can see stars way better with the naked eye than my phone will show. That’s probably just because of stars being point sources and hard for the camera to focus on in an otherwise black night sky.

Another factor is color - our eyes don’t notice it well in low light, so the patches don’t stand out. Camera sensor is equally sensitive to colors at all brightness levels.