I have a friend who's making enough from her self-published young adult fantasy novels that she quit her job as a .Net/Oracle developer. But most of her writer friends don't do near as well.
She says "tell him you have to sell a LOT to be a bestseller. And if you're an indie, you need someone at the NY Times to like you or you'll never make the list no matter how many you sell."