Can a order of emancipation be overturned once granted?

It is possible for the court to do so. That would usually mean that the individual has failed to be a good member of society.