I think you’ve received a ton of good school suggestions for engineering. If you want one of the tech schools, RPI, WPI, Illinois Tech are all great. The southwest has New Mexico schools, the Arizona schools. In the ‘cold belt’ there is North Dakota, South Dakota, Wyoming, Idaho, Montana. All those schools have very good engineering programs (especially in petroleum or hard rock), and most are smaller than the big Texas schools. If he still wants rowing, there are plenty of schools that would allow him both the engineering and the rowing - Embry Riddle in Daytona and Florida Tech are two, but just go up and down the coasts and you’ll find them.
Has your son only been doing Erg rowing? He’d find it much different to go to the NW or NE and be at the boathouse at 5 am (when it’s freezing). My daughter has to be at practice at 6, and she’s always wishing she could sleep just one hour more. Loves it, but it is hard to be on an athlete’s schedule, especially living in the dorms when others aren’t on that up-before-dawn schedule. I’m not suggesting he can’t do rowing and engineering, he can and many do, just that if you want an elite program at an elite school, he’s going to have to be superior in one or the other, or perhaps both, and the stats you posted for academics probably aren’t high enough for admission to the elite schools on grades alone.
On the athletic board, it is often suggested to want to attend the school without the athletics when picking. We’ve certainly found that’s important. My daughter has had a lot of friends recruited and then not like playing. If they don’t also like the school, there is nothing to keep them there. She’s also had friends recruited, quit the team, but still stay at the school.