Just quoting from a post I saw in Hiveworkshop:

Quote Originally Posted by Myutsuu
As the topic. When Thrall meets Cairne, Cairne mentions to him about the Oracle who lives in Stonetalon Peak. But there we meet Medivh. Do you think the legends were talking about Medivh? Or had a true oracle once lived here and he had taken his place?

"Legends say that it saw the strands of fate as they were woven by the Earth Mother. It alone can show you your destiny."

The legends are much older than Medivh himself, so it's doubtful Cairne was referring to him.

At the same time, the ruins of the Night Elves are puzzling. Did the elves worship the Oracles?

"Thrall happened upon the statue in the caverns of Stonetalon Peak during the Third War. The statue's magic created an impassable barrier, and the voice of Aszune spoke in Thrall's mind. The imprisoned spirit told him that she would not allow passage to the Oracle's domicile until her heart was returned to her.

The Pillars of Aszune is a series of arcs on the Broken Isles that lead to the open sea. When Maiev Shadowsong was fighting off the naga forces, her runner got through the Pillars of Aszune to reach Malfurion Stormrage on Kalimdor. The name of the pillars might imply that Aszune lived before the Great Sundering and was rather famous. As a princess, she was very likely a Highborne"[1].
[1] https://wowpedia.fandom.com/wiki/Aszune

also in the wiki:

Quote Originally Posted by Wowpedia
Aszune's name resembles Azsuna, the kingdom of Prince Farondis. The only known depiction of Aszune was found in the bowels of Stonetalon Peak, which would have been located to the far west of Zin-Azshari and the Well of Eternity, while Azsuna and the rest of what is now the Broken Isles were located north-east of the capital. There was also a location known as the Pillars of Aszune near the Broken Isles in The Frozen Throne, which is not present in Legion Broken Isles. The connection between Aszune, the Pillars of Aszune, and Azsuna is unknown.