I think the reason you and others find it intrusive is because you’re not considering why an interviewer is asking. It’s reasonable for an interviewer to want to better understand how this job would fit in with your overall goals for yourself, after all, and that’s all the question is really asking.