I have been doing YIMBY stuff for around 8 years now, and it does not map nicely onto any kind of left-right narrative.
There was one conservative dude who ran for city council here who was all about 'private property' and 'get rid of government regulations', who also ran against the idea of liberalizing zoning.
I've met left wing people who I agree with on many issues who will do the most spectacular, Olympic level mental gymnastics to avoid the notion that 'supply and demand' apply to housing.
There are moderate Democrats who are big backers of various reforms. And some on the far left who get that if you want Vienna style social housing, you also need Vienna style zoning and building regulations.
A former mayor here is a moderate Republican - he totally got what we were about and said some really nice things about welcoming new neighbors in one speech a few weeks after he met up with our YIMBY group.
It's just not an issue that - so far - has been slotted into the trench warfare that other issues have been.
But you literally described the moderates being YIMBY and the more radical being NIMBY, which is left-right, but instead of left vs. right on pole ends opposing, it's the leftists and rights agreeing on NIMBY against the moderate centrists. Horseshoe theory strikes again. There is a growing populist frustration where citizens like both people like Tucker Carlson and Bernie but hate the moderate establishment. Low educated are frustrated with outcomes (ironically being NIMBY on housing is a primary cause) and go extreme compared to the educated moderates.
It's dogmatic among the left that "market based solutions are bad". And because Abundance embraces market solutions, it must therefore be bad too.
Basically, all the arguments I've seen against Abundance tend either towards the ideological, or irrelevant. I tend to see very little empirical arguments.