Unless you are in an area with low light pollution, it doesn't look like it does in photos. You can't exactly increase the exposure time of your eyeballs :D
You see like purple/orange streaks in the sky, still beautiful, but the cameras exaggerate it.