I like to believe that he was somehow released and allowed to pass over (maybe his taking care of Cordy acted as some sort of act of fulfillment or something), because, otherwise, I get this sad image of him waiting patiently for Cordy to return.
On the other hand, once Cordy became a Higher Being, she would have released him if he was still there.