I suspect that this isn’t about rides really.
Are you perhaps worried that she’s too timid in lots of areas of life?
Are you fighting a sense that she’s not like other kids her age?
Are you anxious about her fitting in generally?
Whether she’s an introvert, anxious or neurodivergent, she needs to be able to talk to you without feeling that your disappointed by her differences.
It would be helpful to talk to her about how she feels about what happened. Why did she accept the invitation? Did she truly believe she’d be able to go on rides but then unexpectedly felt too scared to do it? Or, did she know deep down that it probably wasn’t for her, but accepted the invitation anyway? And if so, was that because she really wanted to push herself to try? Or was it because she’s a people-pleaser and didn’t know how to turn down the invitation?
Ultimately, whatever the reason, she needs to get to grips with what she actually enjoys and find her voice without shame. Confidence will come from feeling safe to be herself, not forcing herself to try to be someone she is not. And, as her mother, your acceptance is more important than anyone else’s.