My S23 is the same (astrophysics major). His primary decision criteria was the college with the fewest GEs, so he could just focus on math, physics and astronomy courses. He point blank refused to apply to honors colleges, as they tend to add more required humanities courses. He prefers to add a math double major rather than more humanities.
My D18 was in an honors college. I don’t think it really made any difference after graduation. Her GPA and ECs are probably more important.