So, the Oracle looks like - and presumably is - Apophis. Do we think that she has had a change of heart (after who knows what experiences) and is now on our side? Or is she still playing her own game? I think it's a nice touch that she calls the Imperials "parasites" for using the power of the titan. It would make sense that that strikes a chord with her, as it would remind her of the way Majasa used the lives of the vessel maidens.
I think if it truly is her still that she's still working for Orobyss. She's older here so presumably she wound up in the Imperial Era and carved out a place for herself. My tinfoil hat theory is that she's not the only operative working for/corrupted by Orobyss throughout the story and that our path has been conveniently laid out on front of us from the beginning!