I disagree. Better to let go of dreaming and start being pragmatic. College is not an end in itself, it’s the next stage in a long journey. OP is being realistic.
As for that list of schools- they are simply unaffordable on a $25K/pa budget. OP might be admitted to Syracuse- GPA is in the lower 1/3 of admitted students, SAT in the bottom half- so reachy but not impossible. But the CoA is $75K+. OP is unlikely to get merit aid, and even if s/he did, the average is ~$8.5K.
The others are public universities, none of whom give much merit aid at all, much less to OOS students who are -at best- in the middle of the pack stats-wise. For example Mizzou is a lot less expensive than Syracuese, at ~$45K for OOS, and has an average of $8k merit aid.