This is why AB is such a mess.
You have three answers, two diametrically opposed to each other, and a third smart-Alec comment that contributes nothing.
These responses do nothing, except demonstrate that certain contributors have absolutely no idea what they are talking about. They just see a question, pretend to know the answer and post rubbish with minimal thought for the questioner.
With a bit of research, you can find out that no-one really knows what the ultimate fate of α Orionis (Betelgeuse) is likely to be.
The mass of α orionis is currently some 15 solar masses. When it goes supernova, as it surely will, it will lose a lot of that mass.
If the core that is left over is more than 2 to 3 solar masses, it will collapse on itself to become a black hole. If less, then it will end up as a neutron star.
Current estimates say that stars that start out with less than about 20 solar masses usually end up as neutron stars after the supernova. But that is an estimate. Supernovae only happen every few hundred years in the local galaxy, so we have not had the opportunity to see one 'close-up' so to speak.
The most recent in our own galaxy was in 1604. It resulted in the Crab nebula.
The most recent that was easily observed was SN1987a (in 1987), in the large Magellenic cloud – a small galaxy that orbits our own galaxy. SN1987a took place 160,000 light years away.
https://chandra.harvard.edu/press/sn1987afact.html
Probably the best-observed supernova ever was SN 2020fqv in 2020. That was 60 million light years away. But the astronomers caught it at a very early stage in its death, so they were more excited about that one than SN1987a, which was only caught at a later stage in the collapse.
https://hubblesite.org/contents/media/images/2021/007/01FFN7MSBMTA4GPPNQZ0Y6CX8Z?news=true
Betelgeuse is around 650 light years away. 200 times closer than SN1987a
https://www.skyatnightmagazine.com/space-science/star-betelgeuse/
To answer the question,
• We don't know when it will explode/collapse
• We don't know what the ultimate fate will be. It will probably be (as the question assumes) either a neutron star or a black hole.
• It is unlikely to have any effect on planet Earth
• On the other hand, when Betelgeuse goes supernova, it will probably appear as bright as a full moon in the night (and daytime) sky. That may well confuse nocturnal animals.
But to sum up, AB is not the place to ask serious scientific questions, unless you can find a real expert to answer.
Just use a good search engine and look at sites like Space.com ; Nasa.com ; JPL.NASA.com