I've written two. The second one took me about 33 hours of writing, and a couple of tens of hours more of editing.
But yes, you're not going to make a lot of money unless you're both talented and hardworking and lucky.
In the UK the average full-time author earns below minimum wage - but the average full-time author lives in a household earning well above average; in other words, being a full-time author is, for most people who do it, an indulgence made possible by a two-income, usually reasonable well off, household..
Far more common is doing it alongside another job, and that's true even for a lot of very successful writers - even a few relatively speaking big successes are often not enough to live off unless you write fast and consistently.