Toyota came up with a tank that is very safe.
H2 can be transported the same way natural gas gets transported with pipes and trucks.
And liquid H2 is best suited for rockets. As you say, a real can of worms.
There are H2 refueling sites for trucks that make their own H2 on site with electrolysis. All they need is some solar power and a water supply.
But you are right, there are some things to iron out. They are worth ironing out though, not abandoning H2.
Nuclear power to H2 will allow these new fangled small nuclear plants that can't melt down to operate contentiously day and night without need to adjust to peak power needs.
I don't think solar cells can product enough H2 as demand rises.
Unfortunately, I don't think either of us will be around see H2 take hold.
A new generation of chemists has their marching orders.