This ride isn't the best for older adults, my poor Mom can never ride it because after her neck hurts, but me and my sister ride it everytime, and we don't have any problems. But we are in very good condition from playing sports and we very rarely get back, muscle, other pains, etc. It is a good ride though. Missing a little bit of a story but a very strong concept.
If your wanting to ride but avoid the pain, ride on the Tomorrowland track! There's two tracks on the ride and they're called the Tomorrowland and Fantasyland tracks. Tomorrowland track, yes is faster and shorter but due to its speed and length it isn't as bumpy as the left track. Yes, it may still hurt but you've a better shot riding the right side. The left side, (the side I ride) I reccomend for kids who are younger. Its longer and slower, but you can't really tell, it is a bit more bumpy but I do enjoy the roughness.
If you ask a cast member about that they'll have too tell you its untrue due to fear of one line becoming longer, so don't ask (:
But this rides fantastic, and beautiful. Go ride it!