In agree there are always those few in a community that feel the need to fight everything, even it may be in their best interest and the best interest of the community as a whole.
Anecdotally, I used to live in a rural suburban neighbourhood, the type where homes have large yards between them. There was a proposal to finally put in sidewalks along the residential streets in front of the homes, by narrowing the street a little. This would allows children to walk safely to the new school built, and allow people in the neighbourhood to go on walks, or walk their dogs safely.
Anyways, the amount of push back from some residents saying it will ruin the character of the neighbourhood, or that it would remove vital street parking, or shrink their driveways.
The neighbourhood street was about 4.5 cars wide.
In the end the sidewalks got put in after someone (that did not live in the area), ran over a residents dog along the street.
You seem to be thinking small scale, the concept is decentralised electrical generation nation wide.
Not centralised energy generation such as a single solar plant, a single wind turbine field, a single coal plant, a single nuclear plant.
To cluster bomb a single PV plant (in one attack) would be “easy”, just as easy as a single coal plant.
To carpet bomb a whole nation (in one attack) with PV panels on every home, building, school, sports centre, field, farm would be logistically challenging.