Looking for Advice..

I just graduated from high school and my dream job is to become a pilot. I have wanted to be a pilot since a very young age. I plan on attending my local community college this fall. They offer an aviation science program that is mainly a transfer program where you go for 2 years then transfer to a 4-year school for the other two. The course description says:

The Associate in Science (A.S.) degree is awarded upon completion of requirements for this program.

* Student will satisfy all requirements to earn a Private Pilot License.
* Student will satisfy all requirements to earn an Instrument Rating.
* Student will satisfy all requirements to earn a Commercial Pilot License.

The total cost of the program is $27,000. What schools could I transfer to after this? And do you guys think its worth it or should I persue a degree in something else? What is the job outlook like? Thanks.