TBH, I never thought too hard on Rosalina's backstory. Always took her as a cool addition to the Mario universe - sorta like a magical figure who doesn't need a detailed origin. The mystery adds to her charm imo!