I've got 560 jumps. PM me if you have any specific questions.
First off, it will not feel like a roller coaster. The airplane is traveling at 85-95mph on jump run and by being inside it, so are you. When you exit the plane you are still traveling forward at that speed, however your vector begins to change as gravity takes over. You'll begin to accelerate, however once the drogue is thrown but you'll top out at about 120mph and do it in the span of about 8-10 seconds, so in reality, you're only accelerating 25-35mph in that initial time period. You'll notice the wind and the noise more than anything.
Second...your first time does not have to be a tandem. You can do EITHER a tandem jump, a Level 1 AFF jump, or a static line, however those are pretty much only offered at small Cessna DZs and I would avoid it.
Third...you will not be allowed to wear a GoPro camera. If you are allowed to wear one, go to a different DZ. (A) it's against the basic safety regulations and the tandem system's regulations, (B) you're not gonna catch shit for video, (C) if you want a decent video, pay for a videographer.
Fourth...relax, smile, and have fun. The more tense you are, the less enjoyable it will be. Literally make yourself smile once you're in the plane, it will make you feel better.
Fifth...you (a one time jumper) are more likely to die driving your car to work on Monday than you are skydiving.
Oh, and Travis actually got his licenses revoked for that stunt...but it is pretty badass.
I'm gonna leave this here as proof that I know what I'm talking about. This is me from Thursday and yesterday training:
https://www.youtube.com/watch?v=g8v57uUpz-8&feature=youtu.be