If you went back to the 1950s and asked American kids what they wanted to be they'd say Elvis, Marilyn Monroe. A big timer, a CEO, a magnate, a record breaking singer. And so here we are.
Imo the only point in time any of it will signify a significant social upheaval in terms of labor will be the physical advancements being made in tech, not what kids say. Long as there is no automation to supplement a whole sector of jobs, some kids will always grow up, become an adult, and end up needing practical income and force themselves to take those less than glitzy career paths early on, because that describes probably at least 70% of every income earner on the planet.
That said. Dream big for as long as you can, I say. Just be responsible while you do!