I knew a man who did this. He stayed home with his daughter and somehow managed to start his own business by the time she was in elementary school while his wife worked. He was (still is?) successful with his business.
The messed up part is that by the time his business was off the ground and they were both working, they got divorced. But it wasn't over him being a stay-at-home dad.