hfs asked a fantastic question: what are your natural strengths? Also, what are your interests? Keep in mind that though the two often overlap, by no means do they have to.
Re: Automotive Engineering
Firstly, I can't see your location, but based on your first post, I am going to assume you're at least in North America. Given my experience is through the US educational system, your mileage may vary if you're in Canada, Europe or elsewhere, though Canada should at least still be pretty similar.
Engineering itself is broken down into many different disciplines, each focusing on specific things. Some of the most basic ones include mechanical, electrical, civil, computer and materials. There's a lot more than that, but Wikipedia can probably do a better job explaining what they are than I can. However, just because there are different disciplines, that doesn't mean that there isn't any overlap. At some point or another, an engineer will be involved in something not strictly within their discipline. This means that you must have a broad base and knowledge of how things work, but it also means it's not impossible to move between different engineering disciplines throughout your career.
As an engineer, no matter where at, you WILL be working in a team for a good chunk of the time. Very few products or things are designed or made by just an individual. A team will often have engineers from different disciplines working together to solve a problem (or design something). Each will draw from their expertise while on the job.
To really get into engineering, you need an analytical mind and a natural curiosity of how things work. You don't need to be a genius at math, but you do need to be comfortable with math. There is a lot of math, lots of equations and depending on the type of engineering, statistics. If you struggle in math right now, or you dislike it now, then forget about it. Same thing with science (physics, chemistry, biology), since engineering in a way really is just applied science. For example, how do you take the principals of thermodynamics (physics and chemistry) and use it to build an engine?
Another thing to think about is whether you are naturally curious about how things work. When you see a system such as an engine or suspension, do you care about what everything is and how it all works together? Or if you look at a bridge, do you wonder, and want to figure out, how it can hold so many cars and trucks at the same time without it collapsing? What are the scientific principals at work to make everything around you possible? If you haven't thought about it much, then does it even interest you? Do you get bored if you watch something like
Modern Marvels on History Channel? Are you more like James May or Jeremy Clarkson? If you aren't that interested, or you don't care or you get bored, then forget about it.
An engineer in the automotive industry will get to work on any part of a car, limited only by the discipline you choose. Obviously some things are more glamorous than others (working in F1 vs. working for Hyundai doing crumple zone and safety design). And like journalism or car design, the cooler or more glamorous the engineering job is, the harder it is to get. A job just working as a basic design engineer is not too hard to get, but you will have to have worked really really hard AND be pretty darn talented AND get the right breaks/chances to get into F1 or something like that.
At a company, a mechanical engineer may work on a part of the engine, or suspension, or chassis, or seats, while an electrical engineer may integrate the electronics on the car, while an industrial engineer may work with the manufacturing aspect, or a materials engineer may work with new aluminum alloy mixes or new carbon fiber. The nice thing is that cars aren't going away any time soon, and there will always be demand and an incentive for new designs and improvements, so automotive engineering isn't likely to die out soon.
An engineering job will start you at around $52k-$62k a year (depending on company and location, and also in current job market). That's already going to be on the higher end of the starting pay scale as compared to most other college degrees.
For that though, you will be in for a rough time in college if you choose engineering. You will consistently be overworked, and caffeine will become your new best friend. There will be many late nights, working on homework problems. I remember when I was in the dorms, people will be partying or hanging out on a Thursday night, and I wouldn't be able to join because I still had several homework problems to finish, all due the next day, and each problem took an hour plus to work through. You can still have a social life, but it likely won't be as full as say, an art major.
Even in college, you should be involved in college teams or groups that are automotive related. There are solar powered cars or electric car competitions. There's also stuff like
Formula SAE that you can get involved in to get experience before you go into industry.
Engineering isn't easy, and it requires a particular type of person, but you'll likely get to work on some really cool stuff, and get paid pretty darn well for it.
tl;dr: Engineering requires you to be good at math and science, and you have to have a natural interest and curiosity on how things work and the science behind it. It is tough work to get through, and you'll have to be willing to work hard and put the time and effort in, but you get to do some pretty cool stuff, and the chances of being an automotive engineer is higher than being a car designer, or being a highly recognized car journalist. To work in the top echelons of motorsports though, you will still have to be pretty talented. It's tough, but fun work, if you're so inclined.