He should resign and focus on his health and his treatment and unfortunately he will probably keep his seat and hamstring the senate for 1-2 years.
I doubt McCain resigns with Obamacare repeal on the table. I am afraid most likely he is the 3rd vote to keep it now.