Opposition to energy transition driven by local concerns rather than populism