An incoming comet that skygazers had hoped would provide one of the greatest celestial shows of the century could be a fizzle.