I think the answer is yes. Grown-up coasters are supposed to be powerful and frightening and intimidating.
A kiddie coaster could have a goofy name like Wacky Worm, but I think we're generally talking about bigger coasters.
Well, clearly parks agree with you as 99% of coaster titles go for the same kind of image.
But I think there's a reason that in film casting against type can work well, and I think that a darkly comedic or tongue-in-cheek or even strange and goofy name could go well with a big, terrifying coaster. If they hit the right note, it would make the coaster more of a stand-out phenomenon than the next Goliath or Intimidator or Seriously Scary Thing. I think it would create more personality.
Then again, metal bands these days always seem to go for the same Cookie Monster growl with the vocals, and either you think that's powerful and initimidating, or you think it's boring and kind of sad.