Yup - that's all it is. And you're going to have a certain envelope of negatives (usually far worse than this) in any environment.
So while it does make the flag a bit bless verdant... to call it a "red flag" seems to be a bit of a stretch.
(And as for the substance: agreed, and a capable interviewee should know how to work around those questions and similarly silly ones, like "what's your greatest weakness?". It's a two-way street. And while it's not a positive datapoint, it's hardly a KO-criterion. (viridescent? aquamarine? turquoise? :) )
If you don't have any work-safe dreams, you might want to see a psychiatrist. Again, though, you've misinterpreted the question - They're looking for you to express your spark of passion. It doesn't even have to be for the job. People like people who can talk about something passionately.
That's the charitable reading. The adversarial reading is that they're looking for the emotional buttons to push to maximize your output while minimizing their investment in you.
There's so much zero sum game thinking here when it comes to job relations ...
To me these are two entirely different classes of questions. The first is open ended and meaningless, while the second is directly connected to your career and thus highly relevant for both you and the company. I know where I want to be in 10 years career wise and thus I want to know if this job can help me get there. Equally the company probably knows where it wants to be in 10 years and as such wants to know if you can help it get there.
and
> I'm not looking for a particular answer just an honest one.
are contradictory one to another.
Let me elaborate a little.
My dreams are none of an interviewer's bloody business. I'm here to work not share the things that give me hope in my darkest moments or the aspirations that shaped my adulthood. I find this question very creepy and extremely unprofessional.
I could maybe figure out a "lesser dream" to share, but then what's the point of this question? To find out the most intimate thing that I'd be willing to share?
Where I see myself in ten years is a meaningless question to ask after I've had, what, fifteen minutes of exposure to a company's culture? Maybe I'm the kind of person who sees themselves in management over ten years, but you've got such an amazing working culture that you could convince the most ambitious career builder to stick to engineering instead. Or vice-versa. Or do you really want to hire the kind of people who get an idea in their head, and then do it, even if it takes them ten years and it's really, really, really bad idea?
I've heard all sorts of ways to justify these things. That it's a way to see if a candidate can relate to you and evaluate their empathy -- if anything, this will say more about an interviewer's biases than about anything else. To see if a candidate can communicate about abstract matters -- as if there are not countless questions about ethics, aesthetics and epistemology in our profession that you need to start prying into personal things. That it's a way to see if they're "career-oriented", whatever that means, as if someone who writes amazing code but wouldn't hustle for a promotion is a bad hire.
So far, it hasn't turned out to be a bad idea.