Answer for anyone reading this who may have the same question: this great person has joined my discord and helped me solve the bug.
In short: in order for the hotel to generate income for you, you have to hire a cleaner, it doesn't work if you manually clean the rooms.
This is a bug that I have already fixed and I will update the game as soon as possible.
Sorry for the inconvenience!