Men’s rowing scholarships are not through NCAA but they do exist. the school can give them, private sponsors can give them, but they are just not an NCAA sport (but have many of the same rules for competing, just self governing). I think most schools treat the rowers like they do other athletes with the same privileges and conditions, use of facilities, uniforms, academic requirements. There are many (many many many) athletes at colleges not on NCAA scholarships.
It sounds like your son really wants to row, and if so he’s going to have to apply to engineering schools that don’t require such high stats. I don’t think he’ll be giving up opportunities because I don’t think he’s going to get into schools like GaTech or MIT with his academic stats. If he’s a recruited athlete (I don’t know what level his athletic level puts him in recruiting-wise), he may be admitted to a D1 school but not into engineering.
Others have suggested schools like Wyoming. Your son’s numbers are good enough to get him an automatic acceptance to the university, but I’m not sure about the school of engineering. My other daughter (not in engineering) couldn’t be happier than she is there. She also likes rowing, but no rowing there (lots of other sports at D1 or club level). Your son might like rowing because that’s what he knows. He might find he would like kayaking, mountain biking, rafting, xcountry skiing if that was available.