I am familiar with these schools, and the VA community college system. The answer: it depends on the student. If they are someone who will work hard in a community college environment, then that route might be a good one. It does require two years of dedicated work in an environment where that might not be their first choice. Will they do that?
So I’d suggest honestly considering why the low GPA and SAT. Are there academic challenges–like dysgraphia, dyslexia, ADHD, etc.? Are there motivation issues? Are video games/social media an issue? Are they relatively immature? Are straight-up academics like higher level math or writing just not their interest or forte? It’s fine if any one of these, or any combo, is the cause of the “low GPA and SAT.” Even if it’s not their forte, that’s fine. I know lots of very successful people who did not have much interest or success in school.
If one of the other things (challenge/motivation/distractions/maturity), or some combo, is the issue, addressing that will be important to future success in school. If, rather, academic work is not their interest/forte, a William and Mary or JMU might be a challenge.
I think, too, that it is helpful to not look at it as “just” picking a lower-tier school. There are wonderful faculty, staff, and students at these schools. Many, many students at these schools will go on to successful lives. It really depends on HOW the student goes to school, rather than WHERE. Just like a successful life really depends on getting up in the morning and making good decisions and acting positively on them. Radford and Longwood certainly offer transformative opportunities to students willing to come in and work hard, have a positive attitude, and treat everyone with respect and dignity.
If maturity is an issue, your kid might consider working a gap year. Parents understand that a college education can be important for lots of people (though not everyone), but it can be more difficult for a teenager to see that, to project out 4 or 10 or 20 years and see how performing a task (writing a paper, etc.) might be important to where one is then. Some real-world experience can help a young person understand why getting up at 8 in the morning to attend an econ lecture might be part of an important process, and not the hardest responsibility one might have.
Good luck either way it works out!