I hate to be a debbie downer but getting B’s in Trig/pre-calc is not a promising sign for civil engineering even if your son loves physics and doesn’t want a desk job.
You and your son have an awful lot of opinions- air quality, strippers, weather, too much partying, starting at a CC, snow, etc. none of which have anything to do with the appropriateness of the actual academic programs.
If it were me- I’d be focused on figuring out the right academic and intellectual fit for a kid like this. Your son clearly does not know enough about a wide range of careers to pick a college major just yet and that’s fine. Before you get caught up in “should he major in civil engineering” your son needs to do a whole lot of exploration about what civil engineers do all day. And believe me (I’m married to one), for tens of thousands of them, it is the ULTIMATE desk job. For every day you spend on a bridge or construction site, there are 200 days you spend sitting in front of a computer doing complex algorithms and mathematical computations.