I actually tried to work out the economics of it based on the rate we were paying ($200/night) in a place that was clearly worth at least half a million.
$200 per night. Assuming they only get occupancy on the weekends, and use some weekends for themselves. Then you could reasonably presume they can get maybe 150 rental-days in a year. More likely to be 100. Let's use 100 because it maths easy.
That's $20000/yr. If you were only paying for your place with short term rentals at that pace, and interest wasn't a thing, it would take 25 years to break even. If you include interest at a trivial 4%, then you're looking at a 40 year mortgage.
And that's not including all the cleaning, repairs, etc.
So if you're using the place as an income stream, yeah, that ain't happening. Not unless it's in a high-demand location that you can charge a lot more for.
Unless you're looking at it like a retirement-home-in-waiting or something.

          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
          
Actually, since the whole Star Wars ep 9 debacle, has he made anything? He has some executive producer credits. Maybe he learned his lesson and won't insert random polarbears, err, force diads, in for no reason.