Interesting question! In my opinion, unless you're doing software consulting, if MONEY is the main motivation for a side project, it's very likely that the project will fail. Most projects that end up generating large income streams started as a passion project, where the creator didn't care about money at all. They were just building a community and trying to use their skills to help people. The money only came later, and even then, very gradually over a long period of time.
That being said, if you find people who've successfully built a side income and get them to mentor you, you could probably learn from their mistakes and get there faster. Still, if the passion is not there and the willingness to do it for free or very little money, you will run into obstacles, and without the immediately gratification of money, you'll want to give up.
I would say be a part of the community first (eg, if you're building FIRE software, be apart of the FIRE community), find out what their pain points are, and built products to solve those problems. The key is to start simple and small, test to see if anyone finds it useful, refine it and then iterate. Nothing is perfect on the first try so you have to keep testing to iron out the kinks.
Hope that helps! I don't think there is one magical answer to this question. There are many paths to take to make a successful product, but it takes a lot of time, testing, and refining. So if your motivation is passion, you will last much longer than if it is money. The money will only come when the product proves its worth.