It's the smallest molecule there is. It's really difficult to contain. It will leak out of steel containers while embrittling the metal. However it's not necessary to use pure hydrogen as vehicle fuel. Alcohol or other hydrocarbons can be used directly in a fuel cell to produce electric power, or be burned in an more traditional combustion engine.
Hydrogen leaks out of steel containers because it's "small"? Doesn't the size of even the largest atom (or, for that matter, molecule) pale in comparison to even the smallest leaks you will typically find in a steel container?
The thing that made the Hindenburg transformative is that it was caught on film. After everyone had seen the disaster for themselves, they were never going to trust the technology again.