The government has committed to doubling capacity in onshore wind and quadrupling capacity in offshore wind. Homeowners are worried for their views — but the mood is changing