Is becoming a neurosurgeon a wise decision and does it pay off in the long run?

My view is that you don't need to decide this now. To become a neurosurgeon, you first need to complete an undergraduate degree, go to medical school, and only then specialize in your residency. That is at least eight years away if you are in high school now, and four if you are in college.

So first you need to decide if you are interested in medicine, and then if you are interested in surgery, and then, of all the types of surgery, if you are interested specifically in neurosurgery. So start with first things first. When you get to college, take the pre-med courses like biology, chemistry, physics and calculus - and see how much you enjoy them. And also, take lots of other classes and talk to people in other disciplines, because you need to be able to compare neurosurgery to other potential fields you might choose. You need to figure out what you personally find meaningful and enjoy day-to-day; only then can you tell if the investment in a career like medicine or specifically in neurosurgery is a "waste of time" for you or not. Nobody else can tell you that answer.

http://neurosurgery.med.nyu.edu/education-training/how-do-i-become-neurosurgeon

Great question. I know the medical profession requires many sacrifices: time, energy, money, etc. However, if you truly are interested and confident that you want to pursue this career, there's no such thing as "wasting" your time because in the long-run, you reached your dream job and career. There are ups and downs in every process of getting there, but your hard work and long years will pay off for a rewarding profession.

Gina Kim presents a very thorough summary of the path, someone like you who is interested in becoming a neurosurgeon, will likely be following. You have lots of time before you decide and it's not worth stressing over right now. Take it one step at a time!
It is important to have a plan, but once that is developed focus on what comes first.
(Not sure, where you are in terms of education at the moment, but think about your next step. Is it applying to an undergrad in science? Applying to medical school?)

It would be wise to speak to individuals who are in the profession to get a better sense of what the career entails. You may also find useful information on the Internet by doing a general search.
Do as much as you can in terms of preparing. If there are any volunteer opportunities be sure to take them. Although, you are not interested in research necessarily as your end goal at the moment it may be worthwhile looking for a student research position in neuro-physiology. You become more knowledgeable within the field and obtain a better understanding of the foundation of neuro-physiology. In your senior years of your science undergraduate degree in university/college you will begin to read scientific articles, which are written very differently than textbooks. Much more novel and detailed information. If you were to work as a research student you will be required to read these scientific journal articles, which will likely become very useful down the road.

I cannot see why being a neurosurgeon would not be worthwhile in the long run.
However, as previously stated be aware of the pros and cons of the profession.
Every profession has their own pros and cons.
If you still have a strong interest in becoming a neurosurgeon and have a passion for it then by all means follow that dream. Do whatever it takes to get there.
If your path changes course along the way, so be it.
You can deal with it then.