The whole argument comes down to a certain fraction of the player base that has a medium rank being afraid that the skill (queueing villagers) is being made pointless by a new feature.
It’s likely less then 1% of matches that are being decided by someones ability to keep up a villager queue under stress.
Half (or more) of the player base doesn’t play ranked at all so this feature would just improve the game for them. It’s just another tool they can decide to use or not (like different difficulties, handicap and so on).
Actual pros don’t care about auto queue either because it simply doesn’t matter on their skill level. Not queueing villagers is deciding like less then 0.1% of pro matches.
In my (not very representative) thread [poll] auto-queue >50% of people want auto queue to be enabled everywhere but almost everyone would be ok with it being a lobby setting that is turned of in ranked. No one voted for completely removing auto queue from the game yet.
I later added a poll about auto queue with a disadvantage and no one voted for absolutely no auto queue again. Everyone seems to be ok with an auto queue that is a little slower then manual queueing. But that opinion could obviously change depending on what delay auto queue has. Some people would only be ok with it if it has at last 2 seconds delay (more then 10% of the villager queue time) while other would probably see it the other way round and thing everything bigger then 1 second is way to much.