Yeah, that's what it's supposed to happen. You pass out from it, but awake with a newly found power (which is the ability to learn up to 12 spells). There's no death in the game (aside from game over screens, which are rare). The power you unlock carries over in the sequel as well, so it's a good thing to have whether you are currently doing a magic-oriented playthrough or not.