Why does the aurora borealis appear to be white in the sky but in pictures it has nice coloration?

It depends on how bright it is where you are.

When it's very very dim your color sensing part of your eyes, which are less sensitive to light, don't work. Only the black and white parts of your vision work.

Kind of.