Like any business, video game development can be profitable, but there are no guarantees. Even if your games are well received, it will probably take several years until you see any returns. And even then you would probably make more per hour by flipping burgers. If you’re seriously considering game development as a source of income/career I would recommend getting a book or two on the topic. Those can answer a lot of questions in great detail. I remember The Art of Game Design (by Jesse Schell) and Level Up! - The Guide to Great Video Game Design (by Scott Rogers) being quite good, but I don’t have my copies anymore and don’t remember if they go into the financial aspects.
On the other hand: If you want to go into games development out of passion there should be nothing stopping you - including common sense. ;)
And lastly: To get a vague, initial impression if your game ideas would do well, look at some free games from the same genre (here on itch.io and elsewhere). That’s what you would be competing with right now.
I hope this helped you.