Could a supernova ever destroy Earth?