I'm not a chemist. (Worse, I'm a physicist). But I have several relatives who are chemists. And I work for chemists. I think there's an issue right now, which is that market demand for computer programmers has created a distorted view of all other occupations. That's not going away any time soon, and if it does, there will be some other "hot" occupation.
I think what makes people want to become natural scientists is a genuine interest in how things work, plus either an innate or learned ability to "think" in a certain way that works for their field of study. I don't have a good way to describe it, but a sense that a chemist thinks like a chemist. A scientist is obsessed with learning how things work. The different fields are different approaches to finding that out, that work for their respective domains. Trying to figure out how a frog works by thinking like a physicist will result in a lot of dead frogs.
The other post mentions food science. Stodgy, yes. Fascinating, you bet. Food isn't going away. The problems of making food abundant, pure, healthy, safe, and ecological, are going to get more and more challenging. It can be stodgy because we have to control our impulse to try dangerous experiments on human subjects, or make a mistake that brings down a production line or triggers a recall. But oddly enough there are people who get their excitement out of working within that constrained environment.
You have to embrace the stodge. Something I've noticed about chemists, is that they tend to have the best discipline about running controlled, repeatable experiments. They keep the best notebooks.
Chemistry is closely related to materials science. Any realistic development of a material beyond the basic research phase will require the involvement of a chemist. Likewise drug manufacturing, etc.