Eric,
I did a lot of research into aerogel thinking it was underutilized in outdoor gear but eventually came to the conclusion that the technology isn't ready yet, especially for light weight applications.
First aerogels are typically very hard but brittle. Think the consistency of a sugar cube (and they crumble the same way if they get wet). So as a raw material they aren't the best for flexible or damp conditions. Aerogels need to be waterproofed (which can be done easily now) but the flexibility is much harder to over come.
The current solutions are to crumble up the aerogel and embed it into some type of thick fibrous fabric. This dramatically increases the insulation value of the fabric batting but significantly reduces the insulation value of the aerogel. The fabric then needs to be sealed because any raw edges produce a lot of small particulate aerogel dust which is bad for respiratory health. Even as a fabric though it's still fairly stiff.
More exotic solutions involve vacuum sealing aerogel into channels (similar to sewn through down baffles) which preserves much of the high insulation and adds a minor amount of flexibility.
Basically it's an amazing material but the constraints of the material require heavy solutions that make it no better (if not worse) than current down, synthetic, or sleeping pad solutions. That said, it does work great as insulating insoles for shoes and boots (both for cold and hot environments).
There have been some recent developments in flexible aerogels where they use polymers instead of silica which may result in some amazingly warm CCF pads and maybe paneling for insulation garments (i'm thinking aerogel panels for shoulders to maintain warmth while compressed by packs). Unfortunately these new aerogels are probably 5+ years away from commercialization and probably 10+ before they trickle into the outdoor gear industry (including DIY and intrepid cottage manufacturers).