You can’t motivate someone from the outside. But you can teach. Make your brother a budget both with & without a college degree.
Get him a calendar & show him the research on proper sleep. Don’t hop directly to a solution. First, show him respect & empathy. Then lead him to an acknowledgement of the problem. Work on his fear of failure & get him to just try studying hard for one semester.
<3 <3 :)