All the advice here is good, I wish I'd read this thread back in 1970.
If you want to be a professional pilot, you should be a professional pilot.
If you want to be a pilot AND your family can afford to pay up front for it, then the professional pilot programs at Riddle or UND combined with a major in some technical subject, like engineering or economics, are the way to go.
BUT BUT BUT: Only if you and/or your family can pay the ~$200K that track costs. Do NOT take on huge student loans!! Just don't!
And don't get a degree with the word 'aviation' in it. A professional pilot is only one failed medical away unemployment, you want some kind of marketable skill as a back up. If you continue with college look at a real degree in hard science, engineering, economics, etc.
If you want to work with your hands then consider the 'dirty jobs' approach mentioned by James331. There will always be an aviation related job for mechanics, avionics technicians, aerospace welders, etc.
I just helped a young collegue apply to Air Force and Navy OTS, the Air Force offered to put him in the back of an AWACS or JSTARS, but the Navy offered a pilot slot. He left for Navy OCS three weeks ago. He was a CS major with a 3.2 GPA who was working as programmer.
The Air Force or Army National Guard is probably the number one best place to learn to fly. A Guard pilot gets military flight training, and then gets to pick any two of Guard/Family/Airlines.
If you don't have $200K available or Riddle and don't join the military then your plan of community college and local training sounds good. If you can find another guy with similar interests you two could split the cost of a Cessna 150, fly the heck out it, and build hours pretty quickly.
Good luck and keep us posted as you go along.