I think you need to accept a lot of the time it’s a financial loss.
My parents have one. Fees have gone up. Mum passed away so Dad says this is the last year and he is getting rid. Site fees are almost 6k per year.
However, he can’t sell it privately. He has to sell it to the site. Which will give him far less for it than selling it privately. They then resell it for a lot more.
Some sites won’t allow vans over certain ages. So if the site says 10 years is the limit and you buy one at 5, in 5 years you need to sell it or part ex for a newer one.
Mum spent her inheritance from her parents on it. She loved it. Dad wouldn’t have bought one, but it was what mum wanted.
You also need to pick your pitch carefully. Also look at what are the rules around the caravans being hired out.
Mum got this one after having a van at another site for a few years. At the old one you could privately hire them out and over the years it became a nightmare. It was mainly families and older people when they got that one. Then became over runs with stag and hen parties every weekend. Security out all evening, having to evict people in the night.
That’s why she moved to where they are now. You can’t hire out your van where they are. It’s really quiet, got a pool, clubhouse, beach access etc. lovely setting but expensive.
Also don’t forget to work in cost of gas and electricity, draining down for winter, putting back on ant the end of winter into running fees.