I rather doubt that people are going to chime in and tell you how much money they make.
But I will tell you this: No one starts at the top - with a high end retail store or a busy profitable wholesale business. Unless you have huge financial resources behind you, then making a living, truly making a living without any other income or support, is a very slow build.
I have heard lots of soapers brag about how successful they are, but they have a hubby behind them that pays the mortgage, and bills, or they themselves have a "day job", or a pension, so they can "play business" with their soaping. They never mention that part.
Yes, you can make some money selling soap, but don't quit your day job, or let your husband quit his, just yet.
You said you aren't sure" how deep you want go", but you can have a lot of fun, and make a profit, even at the first rung on the ladder. Start with a local farmer's market or book a few craft fairs. Control your costs, make a good product, build a simple but eye catching display, and you'll probably make money. Get really successful at that level before you move on.
Retail? Renting space? It is very hard to pay a commercial lease in a decent spot, plus overhead and employee costs, and still have time to turn out a quality handmade product. Soap, even great soap, is a relatively small ticket item - you gotta sell a lot of $5-$8 bars of soap to pay that rent