Here's what I'd suggest:
1) Ignore the USNWR rankings. They're useless and come from a survey with an astonishingly low response rate. They don't measure anything that matters.
2) Look at the program that gave you an offer. What are its graduates doing? Are those the types of jobs you're interested in pursuing?
3) Look at the professors you'd work with. What are their former students now doing? Do those jobs match your own interests?
I realize this is an unpopular opinion, but many of the "alt-ac" jobs are jobs that you can hold with a PhD, rather than ones requiring a PhD.
The other thing I'd say is this: if you're especially wedded to one location, don't pursue a PhD in history. While you have a choice as to where you go to grad school, if you're in the lucky group who find a TT job, you have virtually no control over where you go. Most of the existing jobs are at R2/R3/PUI institutions in the US Midwest and South, many of which don't pay particularly well and some of which are in otherwise undesirable locations. Back in the day, the CHE fora had a thread on "embracing your inner North Dakotan."