There are two possibilities for final stage of extremely massive stars. The first is a
neutron star and the second is a

Black hole.

Explanation:

As the massive star "compacts" under its own gravity, it triggers a massive supernova, after this point the remains of the star can become a neutron star, which is a very compact star made primarily, as the name says, of neutrons. The other possibility is a black hole, which is a finite region of space wherein it's interior there is a big concentration of mass, which creates a gravitational field strong enough that there is no particle that can escape it.