Actually, it was the other way around. The ground explosion was a satellite, the one that exploded in the air was an ISS resupply with a Dragon.
In either case though, if it were a BFS stage that blew up, either on the ground or in the air, there would have been no escape options.
You are right that it was an in flight not launch issue.
SpaceX CRS-7 Launch performance was nominal until an overpressure incident in the second-stage LOX tank, leading to vehicle breakup at T+150 seconds. The Dragon capsule survived the explosion but was lost upon splashdown because its software did not contain provisions for parachute deployment on launch vehicle failure.
As to BFS sure if the ship itself blows up that is it. But if the first stage aka BFR blows up there is still the option of BFS being the escape system.
As to the concorde you deflect about sonic booms not acknowledging the flight path issues it had.
I don't trust that shaky cam video, I don't think the camera was firmly attached to anything. As to miles, it's only about 7 miles to the nearest public structure (around Titusville) from SLC39A and about 6 miles from SpaceX landing zone 1 to public structures at Port Canaveral / Cape Canaveral. So whatever the Falcon 9 is doing and Falcon Heavy will do will be at those distances if done in Florida.
BFR will launch from 39A first? (not counting test flights from McGregor)
Now think about Boca Chica! Something from the choices of Falcon 9, Falcon 9 heavy, or BFR will launch from Boca Chica in Texas and there are some houses 1 mile or so from the launch pad (if they lauch from land not a drone ship).
I can't imagine how much the house at 17 Esperson St, Brownsville, TX will shake if that camera shook at 6 miles with just a falcon 9 single stage.
I guess we'll know how close is too close once the Boca Chica site launches something.
here is a random redditors quote about putting it at Kwajalein Atoll for some thoughts on current restrictions at Boca Chica.
Vandenberg and Boca Chica have noise and environmental restrictions. It has been suggested that the best answer is to go back to Kwajalein Atoll for testing and initial flights. This actually works pretty well. You have to ship the spaceship and booster by sea anyway. You have to build new facilities anyway. You want to do the tests far from population centers. Only Boca Chica is cheaper, and that is only true if they can do their tests within the 12 flights a year restriction at Boca Chica.