I've never played a fisherman as a means of being the only income. But I do know that death fish can sell for a lot, so if you quickly get to a level high enough to catch some, then stock a pond on your lot, I'm pretty sure you could easily catch enough each day to support two Sims.