NASA's Cassini probe is about to plunge to its doom — and its fiery death may be visible to telescopes on Earth