Demon represents Hell, Fiend represents Purgatory and Goddess represents Heaven. Just like the three first phases of Kefka, each of the Warring Triad represents one of those three places.
In other words, Demon is, well, a demon, Fiend a "fallen angel" so to say, and Goddess is an angel/god