I say try it if you want to try it.
I also say that the people who really, truly do hate any kinds of drops like that will not be riding it even to give it a try. It won't even be an issue of 'should I or should I.' It just won't enter into the picture for someone who is truly upset by those sorts of things. It's not on the radar for those of us who really, really, genuinely hate those types of rides. Being the thrill-ride hater that I am, I never came off of Space Mountain or any of the Mountain rides when I was younger saying, "Wow! I loved that!" I just don't like them at all. I hate those things. I hated Indy, too, and I tried it. And then I realized that I no longer wanted to try things that I knew I would hate because there was no point! ToT is not on my radar! It's like with the folks who can't ride the Teacups because they know they will get sick - the Teacups are not even a thought in their mind for their DLR trip.
One friend of mine won't even go on POTC because she hates drops, so when she visits DLR she isn't even thinking POTC (let alone about ToT). It's just not on the radar.
Another friend of mine who is merely
okay with some thrill rides every so often - but doesn't love them immensely - went on ToT and came off of it saying it was "mortifying." She will never go on it again.
Another group of friends and I went to DLR a couple of times last year. One male in the group is a thrill ride lover, so he and another person went off to ride ToT. His wife stayed off with me, waiting for her husband to come off of it and tell her if she could handle ToT or not. When he came off of it, HE absolutely loved it and raved about how great it was, but he told my friend (his wife), "Um...yeah...you would not like it at all. Better you stay off of it."
Disney Dreams from the DIS also has a story about an unsettling ToT ride. Not fun.
But...all that said, I think because you are even asking the question in the first place, Brianna, you must
want to ride ToT! So since you want to, do it! Have fun!! Hang on tight, scream your head off and have a blast!!