Sure, it sounds like the beginning of a fun dream, but the air would get very thin, and very, very cold.
Becoming weightless in this magical manner would be a deadly curse. One would be like a dessicated corpse, blown about in the winds, for as long as consciousness and life continued. Not a good way to go.
I just had to post my bits of drek.