This sentence seems a little contradictory to me. If he wants to be an engineer…then he will need to major in…engineering.
Your son is a sophomore…so he is about sixteen. There are TONS of 16 year olds out there who,don’t know what they want to major in at college…or what they really want to be when they grow up.
There is an old saying here…“love the kid on the couch”. Nurture the strengths your kid has, and help him navigate the next few years with that in mind.