Back in 2007, I was surprised to see Rosalina show up. She seemed too similar to Princess Peach and I had wondered why.
Unlike Peach, Rosalina seems more like a demi-god than a real person.
She certainly has a protective role over the galaxy.
At the end of the game, she thanks Mario for the work he had done. Then she’s mostly gone until the spinoffs need her.