40MJ is a bit over 11kWh, which should be enough to run a typical house overnight. My house uses something like 500W average, not counting the car, so it could run almost a full day on this.
For a stationary application, half a ton doesn't seem like a big deal. Surely a normal house can hold up that much weight? That's equivalent to only six or seven people. If the weight is a problem, put it on the ground level or in the basement.
Even a refrigerator-sized VRB doesn't store that much energy, that's ~650 liters so about 40MJ, under 1.5L worth of fuel. And more importantly it weights half a tonne and (assuming it has the same shape as a standard fridge) has an area density of ~1.5t/m^2.