My name is Jennifer and I, too, am a ride weenie.
I had posted here and got great advice before our most recent trip (Dec. 05) so I could attempt to participate more with DH and DS, 7.
The more you push yourself, even a little, out of your comfort zone to try more rides, the easier it gets. I will never, ever, attempt full-throttle thrill rides like Everest or ToT. But, my reward for gathering all my courage and giving Splash a try? Having DS say, on the plane ride home, that his favorite part of our trip was having me ride Splash with him! (My secret was to just take a deep breath and totally relax my body/mind, and the drop is done before you can say zippity-do-dah.) After thinking I could never conquer Splash, I went on to ride it repeatedly (and it DID get easier every time).
I also survived Test Track, Goofy's Barnstormer, Maelstrom, and Pirates (piece of cake). My lesson was that I can try the mid-range of rides at least once, survive, get a little more out of our WDW experiences and share more with DS and DH -- worth the effort!