This notion is not only wrongheaded and historically/culturally blinkered. It is IMO yet another person's "knowledgeable" opinion based on absolutely nothing. Alas, such opinions seem deeply ingrained in the culture at the moment.
And yet, evidence points to some very clear positive benefits of having a working mother. From a 2015 study: The study, which surveyed 50,000 adults in 24 developed countries, found that "daughters of working mothers completed more years of education, were more likely to be employed and in supervisory roles, and earned higher incomes," reports Claire Cain Miller in The New York Times.
And while working mothers didn't influence the careers of sons, they did influence their attitudes toward domestic labor. Men raised by working mothers spent more time on household chores and childcare.
www.businessinsider.com/study-working-mothers-and-career-success-2015-5
Now I absolutely believe that SAHPs can be excellent role models for their children (a point also made by the article linked above). But I also think it's important to be aware of research like this.