Owning parks in the Northwest, we have fought your fight for years. We were much younger than you and your wife when we started having the winters free. We never found what you are looking for. The fact of the matter is the snowbird crowd is much older than you. You are going to be out of place, a square peg in a field of round holes, so to speak. What worked for us is concentrating on the activities that cross over between our age and the snowbirds. To start with everybody eats and like to socialize. We would just have a block party and invite the neighbors to eat and drink. That is a good ice breaker. Depending on what you like to do, you will likely either find some people with similar interests or get leads on other people in the park who do.
We also ended up in an area where it is not 100% snowbirders and where the disposable income for the community is high. That way there is more diversity of activities. My suggestions would be near the ocean or near a major city. The only parks that have come close to filling most of our wants and desires are the old Outdoor Resorts. They are expensive and tend to draw people who are financially willing and able to expand their activities beyond the borders of the park. They are also located in the best seasonal areas such as Southern Florida, Las Vegas and Southern California. It is going to be an interesting journey for you.