How intense is Cosmic Rewind?

My husband, 8 year old son, and I are currently at Disney. On Monday we went to Hollywood Studios. Our son wouldn't ride Tower of Terror because he's still traumatized from when we rode it 2 years ago. He does love Millenium Falcon: Smugglers Run and Mickey and Minnie's Runaway Railway and we rode those and Rise of Resistance, although he didn'tlike the drop at the end of RoR. Today he freaked out when we went to ride Avator Flight if Passage because of the warnings for those afraid of heights. He and my husband ended up exiting early and I rode alone. He was excited about Big Thunder Railroad, but is now saying he doesn't want to ride it. Should we rule out Cosmic Rewind? Is it a really intense rollercoaster? Should we try a rollercoaster at Magic Kingdom to see how that goes? We hit Magic Kingdom the day before Epcot.