My dd’s friend attends USC and is studying architecture and she also knows that there are no jobs out there.
To answer your question, yes $175K is too much debt to take on for the “name” of the school.
Unfortunately, your son won’t be earning enough to repay the debt and that is IF he can find a job.