Our Sun will eventually become a red giant and then a white dwarf.

In roughly ~5 billion years, the Sun will expand into a red giant as it runs out of core hydrogen. After shedding outer layers, it will end as a white dwarf about Earth-sized.