It's not 'scary' at all, but it's very intense. Some people do find they feel sick afterwards, but I also think some of it is hype. I'd read so much about people being sick that I was afraid to try it, but I promise you....no one was barfing in the wastebaskets when we got off the attraction.
I think now that people know to keep their eyes on the screens, their heads facing forward, and not to close their eyes, fewer people are having ill effects.
Make it the last thing you do that day (and not right after a meal) if you think that will be best. But do give it a try. It's really amazing. And no, it doesn't feel like your skin is being pushed back, it just feels like pressure on your whole body, but not in an uncomfortable way (at least, it wasn't uncomfortable to me). I thought it was great!.