At the moment I think it would be good to try and have a few days doing things that have nothing to do with results, such as going swimming or walking, or gardening., on his own or with you Don't ask him about his future plans right now. Not avoiding the situation but just making the most of the weather if it is fine etc. Perhaps he could help you with something or you could go to something together, and some physical effort would hopefully let him get a few good nights sleep and allow him a chance to just rest from the mental efforts and turn his mind to something else. If you put the final and the consequences to the side for the moment, it allows you to remember that you are a person and not just an exam taker. If you let your mind rest and not keep constantly beating yourself up and thinking what shall I do , what shall I do, it will allow your subconscious to work and something may occur to him, or after a break, his mind might be more ready to think of different possibilities , or if he would like to retake later. If he finds it difficult to sleep or not think about the situation he could try my method. Count backwards in 3's from 1000. The point of it is that it takes a little effort to think in 3's so blocks the thoughts going round and round about the situation. He has learnt a great deal over his time at college , and that is not changed by the exam results. He knows more now than when he started. Not only has he learnt a lot about his subject, but has also learnt how to be disciplined in his learning, work to a timetable. debate with others , work in groups dividing jobs so that you either play to y our strengths or learn something new ,find his way round a library and how to support his views, and of course work to a budget and be responsible for how and when he works etc. Whatever he decides to do in the future, all these skills will be helpful in whatever he choses to do in the future. If you can help him to have this gap, then it does allow him to begin to think about the situation and decide what he might want to do next, then it will have been his decision rather than being pressured by his family. Once he has had this chance to see how he feels himself he will be able to ask for help, look into possibilities and then be able to go on being his own person and make choices, rather than be pushed into things by other people. Good luck to him and well done you for being supportive to him, which he wont forget.
One last thing, once you are out in the world of work, having a degree may or not be important but it is like the driving test. If you drive well and have no points on your license no one asks you how many times did you take the test. With the degree ,once you are working, what sort of degree you got or how long it took you to get it becomes less important compared with the way you work and do you do a good job. You also can become a better manager or teacher of people as you will remember how you felt and be more aware of how people learn and the best way to pass on knowledge. (I do speak from experience, been a learner, a college lecturer, Head of communications for a british company , a mum and a parent and a granny) Hope all goes well for him, and in any difficult times in his future, he will be able to look at this situation and see how he got through that and believe that he can manage