I really enjoy Aria too, but I do feel like Pirouette is somewhat better than Mega Lop in one particular way (and noticeably worse in others). The main perk of Pirouette over Mega Lop is its ability to lure in Special walls and obliterate them, making it a really good partner for special sweepers.
It depends on where you use it. Melloetta -P can be great, but not in monotype. Mainly mono spychic has little use for it, since you're gonna wanna use Melo as a ghost imunity, and what cna melo-P not do? touch ghost types