Red Power Star
From the Super Mario Wiki
The Red Power Star is a special Power Star in Super Mario Galaxy. However, there is only one in the whole game. It is located in the Gateway Galaxy after Mario enters the Gate in the Comet Observatory. There, Mario finds Rosalina, as well as a Red Luma, who allows him to use Red Stars to become Flying Mario, so that he is able to collect one-hundred Purple Coins. Upon doing so, the Red Power Star appears.
After collecting the Red Power Star, Mario has access to Red Stars in the Comet Observatory, and is able to fly around the place at his leisure. Other than those mentioned, the Red Power Star has no other special attributes.