My sim drank the ghost goo and is now stuck as a ghost?!

It's a temporary 4 sim hour buff. You can just use Testingcheats true - > sims.remove_all_buffs Other wise bring him back to life the same way you would any other ghost sim.