I'm in noob territory myself just passed AFF level 3 (on my second attempt) yesterday. I can identify with so much of this.
Same here. Ha!
I know that nervousness well!
My first tandem was from a Cessna at a small drop zone and that's pretty much how it went for me too. What had I gotten myself into?
I'm no natural risk taker either. My idea of a good time is drawing pictures, listening to opera, watching cartoons or making cookies. While it's true the sport attracts and appeals to the daredevil crowd, I suspect there's plenty of "wimps" like me who think, Gee, this scares me, but it's %#@ awesome too!
I wondered about that too. I was worried I'd panic or kick, but I did neither. The fact that I had a list of things to do (the dive plan) gave me something to focus on so there was no time to for "Oh noes! I'm falling really fast" thoughts.
Lastly I'm sure more experienced skydivers will answer your questions better than I could, but I wanted you to know that you're not alone.