First, forget the rollercoaster analogy...lots of pilots hate roller coasters. I don't care for them. No control. It's the opposite of what's going on when flying aerobatics. There's little comparison between roller coasters and aerobatics. Rollercoasters are about adrenalin and the "thrill". I don't want to sound like a downer, but aerobatics is NOT about that.
Secondly, it sounds like you have yet to experience any aerobatics at all. You need to figure out if aerobatics is actually for you before thinking about airshow flying. You're putting the cart way before the horse. Many people like the idea of aerobatics, but end up not liking the realities of it. And if you end up a sucker for aerobatics, airshow flying is something you can keep in the back of your mind, but you should focus on gaining experience. Everything MUST be a natural progression. Most folks get into airshow flying because they end up in a position, as a result of the culmination of their experience, to get started with it. It also takes your own money. Don't think for a second that you'll make money flying airshows. You might get paid a little, but that's a whole lot different from making money when you consider the costs. All but about 2 pilots in the country do it as a self-supported "hobby", rather than a sustainable "career", money-wise.
Be prepared for the fact that airshow flying may not be for you. There are realities to anything at the advanced level that are not apparent until your experience has given you a perspective that doesn't exist right now.
Get involved in aerobatics, join the IAC, get good training, start out with something like a Decathlon or Pitts. Don't feel like it has to be the highest dollar, highest performing acro mount. It'll take you many years, a lot of hard work, training/critiquing/coaching, and some natural talent to get to the point of utilizing most of what a high-performance aerobatic airplane can deliver. There are only a handful of pilots in the country who are truly more capable than even the basic Pitts. You can go far with a single hole Pitts, which is the best bang for the buck aerobatic plane. Compete, seek advice, get to know as many folks in the acro community as you can. Never stop learning. Respect the risks. Whatever you do, make sure you're having fun. Competition aerobatics really does provide a good foundation for developing aerobatic skill, precision, and discipline that serves airshow pilots well. One step at a time. Focusing too hard on where you want to end up is a good way to get ahead of yourself before your skill and experience has caught up. And of course, that's a good way to kill yourself real quick.