Nothing here really seems objectionable, though I'd be tempted to clean up and possibly rename things a bit. (e.g, Demiurgist seems a bit more evocative than Realitician.) But it's hard to judge how interesting this would be outside the context of tabletop RP and associated mechanics.
What are you actually looking to create here? Background for a series of stories, or for a CRPG, or something similar?
EDIT: Ooh- one thing I do find interesting in particular- the realiticians'/oracles' ability to forsee the future. This is something that cropped up a lot in the Dune series- Does the the seer, in truth, forsee the future, or actively create it? You could probably base an entire game around that mechanic.