I don’t have any suggestions, just hugs to parents and kid in this situation. I have a smart but spacey kid too; I know how it goes.
He wouldn’t be the only smart kid with great scores who went to a CC and then transferred to a UC, if it came to that.