The rare event was marked by waves of red, green, and purple hues visible in states including Texas, Alabama, Georgia, and Florida