You aren’t going to do better than free. The best option for kids whose parents can’t pay much is to chase merit, but you said you aren’t academic so your options are limited. I know this must be difficult. College admissions is a learning process for most people. If you get accepted to Villanova, I’d attend. One of the advantages of a low cost school (besides no debt on graduation, which is huge) is that you’re not working all the time to pay tuition. You have the time and money to enjoy your college experience and you can travel during breaks.
I think you need to check the acceptance rate of Villanova. Are you competitive for admission? I agree that you need a backup plan. If you don’t want that to be your local cc, you may want to buckle down and focus more on your academics. If your sister worked hard to get the stats needed to attend Villanova while you’ve coasted along because you’re not interested in academics, your parents may think it’s unfair to your sister to reward your performance with an OOS residential college.