I also had hoped to send my kid away to college, and like you, we couldn’t afford our Federal EFC. Unlike your kid, mine didn’t have stats that might have landed her guaranteed merit. So she went where we could afford - the local CC and then an economical in-state public U. She has turned out just fine.
Don’t discount the affordable US option.