Fewer and fewer new retirees are choosing the condo/ park model roots to tie them down to one place in the winter for the next 10-20 years.
While a condo may be best for your desires, my personal opinion is that selling it if your plans / desires change will be difficult.
An RV offers a lot of flexibility, and let’s you explore different areas. Unless you already have a favorite community picked out , I would strongly discourage a major real estate investment.
One other thing. Many of us have made purchases thinking the kids and or grandkids will come and enjoy traveling / visiting with us. Bad decision.
They will occasionally visit, but not enough to be worth investing in extra bedrooms in a condo or a bunkhouse RV. Get the best floor plan for you and the wife. If need be, the kids/gk can spent a night or two on a pallet/ quilt on the floor, in a tent or nearby motel.