After checking my book I see that once you demit, you become Unaffiliated. Regardless of his present residence, a Brother holding a Demit may, within 12 months from the date on which the Demit was issued, petition for re-affiliation in the issuing lodge. The Demit, together with current dues, must accompany the Petition for Affiliation. The petition must take the same course as any other Petition for Affiliation.
If an Unaffiliated Brother petitions a Lodge and is rejected, his demit is returned to him and he remains an Unaffiliated Mason (with no expiration), as long as he continues to petition a Lodge at least once a year.
If an Unaffiliated Brother doesn't petition any Lodge within 12 months, he is afforded all of the disabilities of a suspended Mason.
In addition, no Unaffiliated Mason, residing within the Jurisdiction of a Lodge, shall have the privilege of visiting the same Lodge more than three times, and can't visit a Lodge more than once if it is beyond the Jurisdiction of which he may be a resident.
While there is no mention of Masonic funerals for a demitted Brother, if a valid demit constitutes good standing then it would make sense that he would be entitled to a funeral.