Yes you will be hated a lot.
You will be killing the place you choose and when you do finally retire, there will not be kind or helpful neighbours because of what you have done.
It is their children, their friends who will have been unhoused for your dream, so if you have a fall nobody is going to care or help you.
There is a massive shortage of doctors and hospital beds in Cornwall all year round, and they are put under tremendous pressure every tourist season.
I hope you aren't expecting to get great medical care as an incomer who helped kill another village/town and added nothing to an area for everyone who really lives there.
I've seen so many people from upcountry move down to Cornwall, then endlessly bitch they don't get tourist treatment in areas they have impoverished by inflating prices.
If you want work done, you'll struggle to find anyone because you will have priced most of those people out of the area.
I have known nurses who have to sleep in cars and RVs illegally parked because of second home owners to do their job in Cornwall - that is nurses who you expect to treat you when you come in from your dream retirement home at an age when you are more likely to put high demand on medical services.
There are usually just under 50 ambulances to cover the entire county at peak times so hope you aren't going to rely on one of those as you could be waiting days.
I know what happens to old incomers when they get sick and start bed blocking locals, as there are only just about 1100 hospital beds in the whole county including mental health beds, acute care, the lot.
They are not loved.
Book yourself funeral plans before you move down, because your retirement plan is to die alone in an area where you have left a house empty for 6 years then turned up expecting locals to stand by you and be your community after you have harmed it.
You'll then get to enjoy the airB&B scum too, who will turn up and vomit all over your property while they have a screaming drunk fight in the street and you'll feel about them the way the locals feel about you
I know Cornish people who hate anyone from the next village over and are proud they've never been more than 30 miles from home in their life.
You'll be an emmet til the day you die and if your family live far enough away, they won't bother coming down to your funeral.
Cornish nursing homes are full of old wealthy incomers who get no visitors from one end of the year til the next unless someone is concerned they have been written out of the will.
Family stay in touch for the first bit when incomers move down, but then it's just too far away from their everyday lives and there are other places they want to go in the little time off they have while their kids don't really know their distant old relatives as they hardly ever see them, so they drift away after a few years.
You'll get people coming onto your thread telling you people will love you, it's all fine etc...
I've seen your type countless times over the past fifty years, first their friends who come to visit die off or get too sick to travel so they stop visiting, then their family get caught up in their own lives, then they find they are surrounded by strangers they have nothing in common with.
It's the same story 90% of the time unless it's people who have family already in the area who are moving back.
It won't be so bad when there are still two of you, but there will be nobody to share the strain with when the first gets sick, then after they die you will be alone in a place where nobody cares about you just when you get super needy.
Don't imagine you'll have friendly neighbours who pop in to make sure you are okay when you are alone.
People who can afford to work as carers have been long since priced out by people like you, so you'll struggle to get any home help if you need it.
They might not be rude to your face, but you will have zero goodwill when you really need it as you get older.
You are not of any benefit to the place you want to turn up when you are at your least productive and most expensive stage of your life to a community.
You are the reason a teacher has to live in a bedsit, the doctor can't treat the local guy because you took the appointment, the local primary school has to close because young families have been pushed out of the area by you.
But hey, I bet it's a pretty looking house in the pictures on a sunny day, so what could possibly go wrong?
Enjoy being old, alone and vulnerable with a great view though.