The other issue is that the Little House Books show the situation from the point of view of a child, to whom everything is fresh and new and fun. Mom might have a very different view.
In real life, Charles and Caroline eventually moved into town.
“In 1879 they settled on a homestead near De Smet. When Charles and Caroline Ingalls decided to sell their farm because of the persistent pattern of dry years of weather, combined with Charles Ingalls’ advancing age and inability to take care of his large acreage, he built the family a home on Third Street in the town of De Smet in Dakota Territory. He made his living primarily as a carpenter from that time onward until his death of heart disease at age 66.”
en.wikipedia.org/wiki/Caroline_Ingalls
Failure at farming also afflicted Laura Ingalls Wilder herself and her husband.
“Their first few years of marriage for the Wilders were frequently difficult. Complications from a life-threatening bout of diphtheria left Wilder’s husband partially paralyzed. While he eventually regained nearly full use of his legs, he needed a cane to walk for the remainder of his life. This setback, among many others, began a series of disastrous events that included the death of their newborn son; the destruction of their barn along with its hay and grain by a mysterious fire; the total loss of their home from a fire accidentally set by their daughter; and several years of severe drought that left them in debt, physically ill, and unable to earn a living from their 320 acres (129.5 hectares) of prairie land. These trials were documented Ingalls Wilder’s book The First Four Years. Around 1890, the couple left De Smet and spent about a year resting at the home of her husband’s parents in Spring Valley, Minnesota farm before moving briefly to Westville, Florida. In search of a climate to improve her husband’s health, the pair relocated to Florida.”
“In 1894, the Wilder family moved to Mansfield, Missouri, and used their savings to make the down payment on an undeveloped property just outside town. They named the place Rocky Ridge Farm and moved into a ramshackle log cabin. At first, Wilder and her husband earned income only from wagon loads of fire wood they would sell in town for fifty cents. Financial security came slowly. Apple trees they planted did not bear fruit for seven years. Wilder’s parents-in-law visited around that time and gave them the deed to the house they had been renting in Mansfield, which was the economic jump start they needed.”
“An invitation to submit an article to the Missouri Ruralist in 1911 led to Wilder’s [that’s Laura from Little House on the Prairie] permanent position as a columnist and editor with that publication, which she held until the mid-1920s. She also took a paid position with the local Farm Loan Association, dispensing small loans to local farmers.”
en.wikipedia.org/wiki/Laura_Ingalls_Wilder
It’s very ironic that Laura Ingalls Wilder’s books have done more than anything to glorify the American homesteader lifestyle and yet her family (hard-working as they were) couldn’t hack farming, or at least couldn’t survive just on farming income.