You seem to be talking about professional players and tournament vetoes when I'm talking about casual players and ladder vetoes, so I don't think we're talking about the same types of considerations. Professional players may care about the type of analysis you've made of Celestial Enclave (and I actually agree with your analysis when looking at the map from that point of view), but every conversation I've had with casual (macro) players who've vetoed Celestial Enclave doesn't go that deep. They've played the map, they've gotten proxied in the backdoor base because of the worker-only path, and then they've vetoed the map. This isn't them turning their brains off. This is them being smart enough to realise that they're not getting anything out of the backdoor base themselves (macro play in LotV is too streamlined for the backdoor base to be a worthwhile consideration) and so they don't bother with it, and I don't blame them.
EDIT:
In the same way, casual (macro) players who've vetoed >2P maps don't do so because of some deep analysis of the map layout. They've played the map, they've gotten cheesed once in a way that was impossible to scout due to RNG (or they've played a Random player and been unable to select a build fast enough due to RNG), and then they've vetoed the map. Once again, this isn't them turning their brains off. This is them being smart enough to realise that they're not getting anything out of >2P maps themselves and so they don't bother with them, and I again don't blame them.
Then again, maybe I'm being too relentlessly pessimistic due to my feelings on how LotV has been streamlined. I have a very hard time seeing how maps can make the game more strategically interesting when I don't think the game itself is capable of being anywhere near as strategically interesting as WoL/HotS due to the 12 worker start.
EDIT2:
It really comes down to risk/reward.
WoL/HotS gave the player more options in the early game because there was a greater selection of viable builds. This meant that >2P maps and non-standard maps gave players a chance for experimentation, and so casual (macro) players felt like they had something to gain from playing on >2P maps and non-standard maps.
LotV doesn't give the player options in the early game. To take an example, if you're playing a macro PvZ then you're opening 1 Gate FE whether you like it or not, so why would you want to worry about failing to scout a 12 Pool in time due to RNG when that RNG isn't giving you any extra options? It doesn't make sense to bother, and so people don't.
It's really not about players turning their brains off. It's about LotV being so aggressively streamlined that it doesn't give interesting maps room to breathe.