In an ideal world plagiarists would always be caught and always be failed. No need for dire consequences. Just no rewards. In the real world, most plagiarists are never punished even if they are caught. If you're a TA or prof and you think you've been given plagiarized work, you need to have iron-clad proof before you can even think about breathing the 'P' word. You can easily wind up in as much trouble as the student if your proof isn't solid! You have very little to go on if the student is at least smart enough to paraphrase and avoid copy/pasting complete sentences. I've been given work I was 99% sure was plagiarized but, since I couldn't prove it, I couldn't do anything more than give it a low grade. Even when you can prove plagiarism has occurred, you're in for a
lot of extra work. Usually it's easier to just talk to the student and tell them to withdraw from your class.
Since plagiarists are so hard to catch and punish, it's important to make examples of the ones who are caught. You can argue that this was "just class homework", but students who plagiarize homework are the same ones who hire ghost-writers to do a one-off term paper or thesis for them. If they can get by without doing the unimportant work, odds are they won't learn how to do the important work.
In this case, absolutely make this kid's life hell. It doesn't matter if he only cheated that one time or if that's how he got his entire degree. What's important is that other students see that plagiarism can come back to haunt them long after they've gotten their degrees. The student's profs ought to be made to sweat a little too. Missing or failing to punish plagiarism is entirely forgivable for the reasons I have stated above. Giving a passing grade to an obvious joke paper shows that they were negligent, and that's another matter entirely.