I used to be a ride chicken also, but I went to WDW with my 13 yr. old niece and realized that I had to gather my courage and get on some of the rides that I dreaded for her sake. Guess what? I realized that they were very thrilling, but not near-death experiences! All except for TOT, that WAS a near death experience, since I HATE the falling sensation. I do like speed though, and so Test Track and BTMRR were a blast.
I slowly desensitized myself and now I actually enjoy the thrill rides.
I would definitely recommend that you stay away from TOT, Rn'RC, EE and SM. I have observed that there is a very creative science to psychologically scaring you before you get on a thrill ride. Some more obvious than others. Just keep remembering, this is Disney, not a shady carnival and you can out wit the fear tactics.
One more bit of advise, if your family wants to ride the thrill rides, get in line with them and enjoy the wonderful theming of the queue and the pre-shows. When you get up to the loading area, tell them you aren't riding and they will show you the "chicken exit". Seriously, they all have one. As well as chickening out, people have to use the restroom or have to get to a dining reservation, etc. It's no big deal at all. Then you can wait for your riders in the giftshop.
I rode EE 2 weeks ago and the ride is fantastic, but it IS a big, major coaster. The theming and the queue are fab though, and well worth seeing.
Have Fun!
