No, the Sun will never become a red dwarf star or planet. Red dwarfs are small, cool, main-sequence stars. They represent the most common stellar type in the Milky Way galaxy.
Our Sun is classified as a yellow G-type star on the main sequence. As it evolves, the Sun will eventually exhaust its nuclear fuel and transition into a white dwarf, not a red dwarf.