if you activate the switch the royal wizard will then be able to invade your world at random intervals and be a pain in the ass..

if you want to do his assassination quests, you must be hollow, not human form, and then you must talk to him for his quests and get magic/pyromancy rewards. if you open switch you are no longer able to do his quests.