> On the other hand I've heard the point made that if a clear night sky was as rare as northern lights or an eclipse, people would similarly be freaking out about it as a life-changing almost religious primal experience.

Which of course they are in large cities. And city dwellers often do have such a reaction to a clear night sky in a dark place where you can actually see all the stars.