What will become of the Sun after the red giant phase?

The consensus is that its core will stabilize as a white dwarf, nuclear reactions will stop, and the white dwarf will cool over billions of years from 100,000 K to a few thousand degrees. There are hundreds of known white dwarfs.