I've worked on eight titles professionally working for game companies that never made the money spent developing them. It's a hit driven industry and there's no guarantees, unless you hit on an untapped market with a lot of pent up demand for something (like Natsume had been dropping the ball and releasing garbage Harvest Moon sequels for over a decade at that point, Stardew Valley came along and showed them what the fans actually wanted). Even then it's still not a guarantee.
I'm out of the video game industry now, but still work on my own games, but it's only a few hours a week here and there. I've had some success over the years, but not enough to justify asking my wife to let me quit my job and do it full time.