Long story short if I remember the video well after watching it a while ago: while sand is cheap for thermal energy storage, storing it with reasonable efficiency requires a massive unit (much higher capacity than one home would reasonably need; can't be scaled down well) held underground (immediately incurring massive costs).