The wikipedia page actually has some incredible images as well, including several from space that show their scale and position in the atmosphere (high up)
that shot with them aligned with Milky Way is spectacular
yeah, its pretty cool how most of these photos they were trying to take a picture of something else and the red sprites just happened to be in the right place because of a storm front moving in.