Usually that expression is used to mean that someone is nervous. Although I think it could work in either context. For instance, in the roller coaster example it could be assumed that the roller coaster was a thrilling or nerve-wracking experience.