Aurora doesn't have much agency in the film, it is true. But all the characters who do have agency are female.
The fairies are the protagonists, Malecifent is the antagonist. Saving Aurora is the goal they fight and plot over. Philip is a sidekick and the Kings are comic relief.
This is true and a good point. Female villains do actually quite often get agency in fairytales - the evil queen in Snow White is the same.
This is a pet subject for me, because I think the way femalehood is illustrated in fairy tales is fascinating - it's a perfect example of the Madonna / whore complex.
There is virtually no space in traditional fairytales for healthy / normal female sexuality; virtually every woman who has a baby, for example, dies. Snow White, Aurora, Cinderella, Belle and Ariel are all motherless. What you get instead is a dichotomy between the pure, virginal angels (the princesses) and the monstrous perversions (evil queens). There might be the occasional benign sexless spinster as well (the fairies, the fairy godmother).
In that framework, the women who have the most agency - specifically, the villains - have this agency because they have turned their backs on their femininity. They serve as examples of how monstrous women become when they aren't in their proper place.
(This is obviously not the pattern that all Disney films follow, but those rooted in traditional fairytales do).
Fairytales are ultimately morality tales. Although they contained subversive themes - magic, monsters, desire etc - they were ultimately designed to reinforce the prevailing morality of their times. The purpose of them is to reiterate to girls that their job is to be industrious and obedient and self-controlled and cheerful; if they aren't, the evil queens represent the fate that awaits them.
That's why I think it's difficult to extract a positive feminist message out of the more traditional Disney films; the source material actively resists it. That doesn't mean the films aren't fun or that kids shouldn't be allowed to enjoy them. But to my mind, they should come with a health warning that wholeheartedly buying into them as examples of how nice girls should behave isn't a great idea for modern girls.