Odds are that they are Republican counties because wind and solar tend to be built in rural areas and rural areas tend to be Republican. I would actually expect Democrat held areas to also oppose them because people in general are NIMBY.
That said, there are a bunch of valid reasons to oppose large scale projects that can be addressed. A primary problem is the disruption to the local area, either by destroying roads not designed for the heavy machinery or the government taking land from locals that is necessary to implement the project. Both could be handled differently than they tend to be as the large companies that implement these projects tend to not care about locals already living in the area. Some ways they could improve the process would be to improve the roads and offer better compensation for affected locals, but there are valid reasons that some retired person who lives in the home they grew up in to oppose a power plant even if it would be a net benefit to society.
That is to say it is complicated and the best that can be done is better treatment of the people that are impacted by these projects while understanding that some are just complaining to complain and some really do have valid complaints that need to be better addressed so progress can be made.