A comet recently discovered zooming through our solar system has the potential to be quite bright when it arrives late in 2024, but comets have let us down before.