My son loves airships (thanks Mario and Bowser lol) but I think the main issue is that even with the most buoyant gas we can use, hydrogen, physics doesn't really allow for much lifting capacity once you add the lower compartment where passengers or cargo would be. Even the Hindenberg had a lightweight grand piano made, but eventually had it removed to save weight.
The numbers look even worse with helium, and it's a lot easier to make hydrogen than to capture enough helium. I'd love to see some kind of hybrid airship/aerofoil system that could lift more with powered assistance, but I don't know if that would be more or less efficient than huge cargo jets.