Asteroid 2023 CX1 was spotted in Europe Sunday night and hours later the meteor was seen burning across the sky over France and throughout the region