We were in the same situation a few years ago. We loved Ruidoso and being in west Texas, it was a short 3-4 hour drive for us. We bought a condo there with the plan of renting it out to pay for itself/make money. I wanted to self manage because I knew I was too much of a control freak to have a property manager, and the money didn't make sense.
It pretty much paid the bills/resulted in a small loss annually. The area is so oversaturated with vacation rentals and between utilities, HOA fees, supplies, and repairs, it was hard to make a profit.
The worst part was trying to find a reliable housecleaner. We had one who was decent but then she decided to move to Florida but still run her housekeeping business in Ruidoso. She forgot to clean one time and the next guests arrived to a dirty house. That was the beginning of the end for us. Next housekeeper was on drugs, I'm pretty sure. The one after that was ok for the short time we had her but she wanted to do everything "her way."
The next problem was the guests. They would book the condo for 6 people and show up with 14, disturb the neighbors, and steal things. There was one geographical area that guests came from which guaranteed they would be terrible. Never failed.
We got shut down by the state of New Mexico during COVID. The guests got progressively worse during and after that, and with rising real estate prices, we decided to sell.
Airbnb as a platform is just a tool. Of course they aren't in it to be your friend. Some things in their TOS are not pro-host. I could never gain traction on VRBO because it seemed like priority placement was given to existing long-standing listings.
I have a vacation house in another area now which has experienced none of the guest and housekeeper issues that I had in Ruidoso. I also use Airbnb for mid-term rentals. I would suggest looking at AirDNA to get an idea of occupancy rates to base your numbers on. I would be happy to discuss more details about my Ruidoso experience if you're interested.