If the net price calculator indicates that you cannot afford the school, it’s not worth it to apply. The money won’t magically appear. If you had a decent shot at a competitive scholarship, the NPC would have likely indicated that in some way (but also letting you know that it is in no way guaranteed).
Getting in, but not being able to go seems to be resentment and bitterness waiting to happen.