Bad advice. It is not the problem with question when you feel it that way. It’s the problem with engagement of the manager. It’s perfectly normal to ask „How are you?“
Sort of. Questions are tools, tools can be used incorrectly. It doesn‘t mean that every manager asking „How is your wife?“ is an idiot or that is inappropriate question in all situations. It may take a lot of time working under idiots before you meet a decent person, but they will ask those questions at some point and you will be happy that they asked. Better to teach the appropriate use.