I think it may have to do with what aspect of roller coasters you find scary. If it's the speed, as has been already said, neither Space Mountain, nor Big Thunder are particularly fast. If it's about height, then in my opinion, Space Mountain shouldn't really be much of a problem since it's hard...