I always figured when the Goddess brought Twilight into herself she eventually became Nightseer. So eventually Littlepip ended up killing her body which is why we never see a Alicorn Twilight after the Goddess's death and they all regain bits and pieces of there memorys.