The Wayward Queen attack isn't something I'd consider "aggressive." It is just questionable to bring the queen out that early. The opening is tricky for beginner to intermediate level players, but eventually you see these early queen attack openings much less.
The Sicilian Defense doesn't have to be aggressive. Many lines are, but other variations aren't. It's a rich opening which can go in many different directions and many people avoid recommending the Sicilian Defense to beginner/intermediate level players. It's not my personal choice, but if a beginner/intermediate player wanted to play the Sicilian Defense, then I'd let them as long as they have a general idea of what they are getting into.
For beginner to intermediate level, I would first ask them what their chess goals are. I'd recommend different openings for different reasons. If someone wanted to improve their overall chess understanding, then that's different from someone who just wants to win against a specific friend. Improving overall means developing good habits and a strong foundation on things like opening principles. It may also mean experimenting with many different openings to get a variety of pawn structures and positions. If they just wanted to win against a friend, then learn what that friend plays and specialize in one setup against that, or choose something like the London System which is easily repeatable with minimal effort needed for memorizing opening theory.
For many, just grasping opening principles is good enough to help a lot and light memorization on top of that is mostly all that is needed:
https://www.chess.com/blog/KeSetoKaiba/opening-principles-again
aggresive openings i know are the wayward queen attack and Sicilian Defence