Most skilled trades are not hard labor. If you're a plumber, you might only bust rocks or dig ditches 10% of the time. And it also depends on what you specialize in. The guy that replaces your toilet and your busted water lines might know how to build a septic system, but he probably hasn't done it in a while.

Honestly I'd be really tempted to get out of software and go into a trade. It'd be a lot less work.

I think you're underestimating what it means to perform a physically demanding job. It's not like that weekend you spent painting your appartment. It is something you do five days a week, for weeks and months on end. In my late thirties I was sick of being a software developer and I did a two year stint of being an electrician for a big construction company. It was a wonderful experience and I learned a ton of stuff about a ton of stuff, but in the end I was very happy to go back to a heated room where I can work sitting in an ergonomic chair while sipping a cup of coffee. Honestly, if your body was not trained to do this from your late teens or early twenties you will likely not last.

This is a great idea. I don't think community colleges can do this, at least today. Having a focused night time set of classes in practical methods of running a business would be required.

Edit: typo