As a parent, I know how you feel, and I’ve felt that way too. I’ve watched my kids fail at endeavors that I knew were bad ideas.
The big question is whether it’s worth it to force him to go to a school he doesn’t want to attend when he has a full ride award to the one he wants. There is often fall out from forcing something line that. I’ve seen it many times when a student is resentfully going to a school because it is forced upon them that it does not go well. When there is financial aspect to the choice, it’s time young adults learn that people can choose to spend their money as the please, and if a parent feels that paying for a given school is not worth the money, that’s it. Many kids are going to colleges based on affordability.
Yes, it will be a loss of the scholarship to the school you prefer if he goes off to another choice. If things don’t work out at his choice, an affordable local state school is probably where he will have to go unless you are willing and able to pay for college. But that would all be on him that he is in that predicament. Let him know what the outcome is going to be in such a situation.
If he goes to you choice of school, and it doesn’t work out, you are likely to have one bitter son who has also lost an opportunity to go to the school he wanted.