It's a very small village but very close (2 miles one way, 4 miles the other) to much bigger towns. In the village there are 2 pubs, cafes and restaurants, one hotel, a couple of gift shops... No school. No nursery. No GP surgery or dentist or optician etc. It feels like a holiday village. There are quite a lot of holiday homes but they don't seem popular outside of school holidays really.
So what you're saying is that the local amenities have already been destroyed by second home ownership, and you want to continue that pattern?
Properties stay on the market for ages. Some houses sell reasonably quickly but flats have been on the market for months despite being share of freehold and very reasonable service charge.
Probably because second home owners have pushed the prices out of the reach of the ordinary local people - like the ones who work in the pubs and cafés you'll no doubt want to make use of - how do you expect those businesses to continue if they cannot get the staff because the staff can't find affordable homes?
We would not rent it out commercially as there seem to be too many problems associated with that nowadays but would let it cheaply to family and friends if we weren't using it eg in school holidays. We would use it quite a lot and could WFH there sometimes (we both do blended work) or just go for a break. We would definitely use the amenities such as cafes and restaurants etc, as would any of our family that were using it. Our adult children would also use it.
Leaving it empty for most of the year is the most unethical option of all - how will those cafes etc survive when even the cottages don't even have holiday makers? As problematic as Airbnb is, it does at least supply a steady stream of people wanting a cream tea at the café.
I don't think we'd be taking it away from families that desperately want accommodation there.
You keep telling yourself that.
Until everybody has one home, noone should have two homes.
Your proposed course of action is the most unethical option open to you, short of turning it into a knocking shop.