The eventual fate of our Sun is to?

The Sun will evolve onto the Giant Branch, then collapse down to a white dwraf. Its m is well below the Chandrasekhar Limit, so it cannot explode, which would be necessary for it to become a black hole or neutron star.