Many social activists were famously unpopular. Martin Luther King died with a 66% disapproval rating^[1]. Susan B. Anthony was ridiculed and accused of trying to destroy the institution of marriage (sound familiar?).
Of course some activists veer too far. Jane Fonda is an example. I don't fault her opposition to the Vietnam War, but her infamous photo practically advocated for violence against American troops.
In a sense the aim of social activists is to be ahead of their time. MLK was reviled in his time and practically infallible today. We need both politicians and activists for progress. Politicians push forward the policy, but the activists push forward the politicians. Without activists, politicians can end up in holding patterns, afraid to lose popularity. Without politicians, activists are just screaming into a void.
[1]: https://www.newsweek.com/martin-luther-king-jr-was-not-alway...
Being unpopular is hardly the same as being abrasive and rude.
Its funny how the people endorsing Obama's experience on the "defund the police" slogan losing people seem to ignore the other "error" he mentioned as losing people in the same interview: giving too small of a platform within the Democratic Party to voices like AOC's (who, obviously, has the opposite view as Obama on "defund the police") who have proven quite effective with connecting with large constituencies with which the party establishment (implicitly, including Obama himself) has been ineffective.
I would be cautious in selectively referencing that Obama interview to suggest he knows better than "The Squad".
The fact is that Obama has got way more done for America than Omar, so I'm inclined to think he's right.