The author does say "I have been warned against going full time indie by everyone on the internet and by my friends and family. I believed I could make it, all I had to do was ship just 700 units of my game on steam." They also say "After more than 10 years of writing games I believed I had acquired enough know-how, knowledge and experience to make it in the industry on my own, on my own terms and on my own schedule." [my emphasis].
That implies they had thought about the financials, and were believed they'd be able to get a sufficient amount of revenue.
what you describe is basically the entire human condition as it has ever been since time inmemorial.
Art is the culture that underpins society. Normalizing the idea of sacrificing to create it is itself antisocial.