I would worry it wouldn’t be steady enough to make money, so I would lose out compared to renting a room out. I would have to require them to clean up after themselves too, and vet them like renters so I would feel safe with them in my home
Especially if you are out working during the day, you could actually rent out your own desk space, rather than additional space.
Essentially you are right - unless offices close down big time, there is going to be less supply for workplaces than for holiday accommodation.