But anyway, the reason people are fascinated with the idea is that vacuum is a renewable and abundant resource. Heck, space is almost completely full of it.
All of the lighter-than-air gases I'm aware of have downsides, like hydrogen's permeability and flammability, or helium's rarity and price.
Something interesting to think about is if they don't leak heat energy very well, and the exterior is something heat proof (steel foil?) you can heat up the air inside to arbitrary temps until radiative glow exceeds the other thermal losses. So if you think nylon hot air balloons are high performance, imagine balloons with much higher lift per volume. A liter of air weighs about a gram so its always going to take a large piece of aerogel to lift me (I weigh quite a few grams) but ...
A hot air balloon sized piece of aerogel is not economically viable right now, even for the military... or is it?
Also, the reason airships use lighter-than-air gas is because then they don't have to carry lots of heavy fuel for heating air. Things like fuel, and pipes to carry heat throughout your aerogel, will rapidly eat up any efficiencies you gained.
Afaik hydrogen tends to slowly diffuse through metals and embrittle and corrode them in the process. And a solid-metal hull probably is ideal for airships anyway.
If the ship had been made out of metal it would've sprouted a brief jet of flame, then crunched to the ground in a fairly ungraceful manner, but it wouldn't have exploded.
Maybe a graphene hydrogen containment cell could work? That would be strong enough to deal with the pressure, plus provide a flame resistant barrier.