What happens after a sprite explodes ?

It’s gone.  In Tavris and Fefeta’s case their ghosts returned to the dreambubbles.