My aunt lived in a park home, on a site, for several years. Later my cousin got a unit there, too. They seemed quite content and the site owners were sometimes helpful. My cousin now lives in another park home somewhere else having lived in a house in between.
I'm sure there are things that aren't so good, like the insulation, but I can see lots of advantages, too. Nice if you have a bit of garden that's easy to cope with, the home will be 'compact' (!!) so will be easy to keep clean. If it's on its own freehold plot it's better than on a park.
It might be a better way to release capital than an equity release scheme - at least it will be all yours!