Democrats will make him a national hero for 'standing up to Trump'.
McCain will get the full Bush treatment (the current positive one, not the old negative one) once he's safely off the scene.
It's like that with every politician, though. People always invoke the dead or retired ones in order to bash the ones who are still active.