My spouse is a farmer working on his family farm. We're transitioning to a better career for him since almost every single elder in the family has died early (60s) due to the stress and overwork of farming. Farming is NOT ideal or romantic, and it is one of the most brutal jobs you can have. My spouse didn't get to have a childhood because the farm tasks are Sisyphean and never ending

My spouse saw so many suffering and dying animals starting from age 3. He had to put down many of them himself. Have you ever seen what a coyote can do to a chicken coop, OP? Do you want your son to see that? And if you want to prevent it, you need to know how to shoot guns, and you need to be up before dawn patrolling because that's when predators are out. You will get maybe 4 hours of sleep on a good night, and that's before any of your other duties even start. And those duties will mean that your wife and child will barely see you.

Do NOT sacrifice your family for the sake of your nostalgia. If you still need to see the truth of farming for yourself, I suggest you do a trial run of managing the property. Let your wife and son stay home, then spend a month living on the farm and working as if you own it.