Should one major in what he is good at or what offers more money in the future

I am a professor. I have seen many students choose a major they are not good at. Sometimes it is for the money. Sometimes it is because they think the career will be "cool" but they do not understand what kind of preparation they need. Sometimes it is due to parental pressure. Sometimes it is due to restrictions put on them in order to qualify for a particular scholarship.

And often, I have seen these students flunk out of college.

You won't benefit from a field that pays well if you never actually qualify to get a job in that field.