No, I was purely using "Oedipus Rex" as an example because in the order of Sophocles' plays, "Oedipus Rex" (translated as Oedipus the King), lead to "Oedipus at Colonus" and was ended by "Antigone" as a tragic cycle. The order is very similar to "Dune", "Dune Messiah" and "Children of Dune"'s places in the overall series. The first trilogy is overall a tragedy, so I see many parallels, especially since Oedipus is blind for the entirety of "Oedipus at Colonus" similar to Paul's blindness and wanderings after a certain point in "Dune Messiah", as well as the idea that tremendous forces have to be confronted by Oedipus' progeny in the form of his daughter, Antigone, while it falls to Leto II to go further and do the hard work necessary to ensure the Golden Path is successful. Indeed you can look at "Dune" as being about what happens when a superbeing uniting male and female aspects is created - he didn't have an incestual relationship in the physical sense, but he understood his mother as his father did, and had access to those memories. As Jessica later says about Leto II and Ghanima when they reproduce those memories, "it was an Abomination" - she felt stripped bare before them with knowledge that no child should know firsthand. It is the gift of Jessica's heritage as a Bene Gesserit and genetic bloodlines that opened up the prescient abilities in the Atreides line.

But, yes, Aliah has prophetic powers in "Dune" and "Dune Messiah" - they are waning in the second book, though, which is why she started taking more massive dosages of spice and how she became an Abomination. She was not a full blown Kwisatz Haderach, which makes sense since she was to be the female Atreides that would have given birth to a Atreides/Harkonnen son that would have the full powers. This is alluded to in her early birth, where she already was being talked about by the other Fremen because she knew things that had not happened, yet, and already had the maturity of an adult. You might have missed this in "Dune", but she uses her limited prescient abilities to manifest thoughts into Mohiam's mind - she uses this to communicate with Paul:

Of all the uses of time-vision, this was the strangest. "I have breasted the future to place my words where only you can hear them," Alia had said. "Even you cannot do that, my brother. I find it an interesting play. And ... oh, yes — I've killed our grandfather, the demented old Baron. He had very little pain."

Also, in the training sequence where Alia is fighting the sword training mechanism, she remarks that she is now the match of about seven Ginaz swordmasters. Duncan himself never gave his rank, but the implication is that she has pursued the utmost physical capabilities of her prana-bindu training to exceed what he (and Paul) were capable of. This lead her to start exploring the Bene Gesserit forbidden controls of manipulating the aging process and etc. It is this same ultimate control that she uses to wrest muscular control from the Abomination of the Barons' control, and commit suicide.

Alia is an interesting character because F.H. gave hints of what she was capable of, showed the obvious evolution and did very well in following through on them throughout the trilogy without giving up all of her secrets. She comes across as a very relatable person at all steps of her sad journey.

I really love these characters and my affections have grown after multiple re-readings, especially having read Frank Herberts' biography and etc, and I can appreciate how he placed jewel-like "hints" as to real motivations throughout the series.

In the end, the series had a great resolution in "Chapterhouse", with each human now being fully "human".