I doubt he would want to continue as Kazekage. He wouldn't really be able to protect the village that effectively anymore. It's not like he was the ruler because of his experience or any exceptional wits in the first place, I think. Kazekage is probably supposed to be a ninja of formidable proficiency, and Gaara wouldn't be that anymore without the beast inside him. So, even if the others wanted him to continue, I'm not sure he would agree himself.