It is, I think the overwhelming majority of people want to be able to go out to dinner, or even lunch without having to drive when on holiday. It doesn't mean they would do it every day, but they like the option.
I notice all your thoughts are based on what you do on holiday, you make no mention of going out in the evenings, and plenty of people don't want to cycle to the bakers etc, they prefer to walk.
I think instead of picking a holiday home you can rent out, you're picking where you want to live,even though you understand the requirements for both can be very different,
I think if you really want this house, then think of how to make it work practically for you, accepting it will not be rented out for the vast majority of the time,
My father in law did the same. Bought a farm house in France, said he'd rent it out and live there for a few weeks a year. Except he bought in th middle of no where. In what was not a picturesque place and you had to drive everywhere.
In the several years he owned it, no one ever agreed to rent it. It was even a ballache for us, as you felt trapped once there, as lovely as it was. He kept saying but you can be in Spain in an hour, and all other manner of random shit about why it was desirable, it simply wasn't. The idea of it was, the reality was far from it,