Why have cargo hybrid airships not succeeded in the market?
First of all, there is the question of demand. There aren't enough cases where a very heavy load needs to be moved to a remote location by air. There are probably even fewer where there are funds to actually pay for this option. The An-225 is currently the largest aircraft in operation, and it was only constructed under special circumstances. Although has certainly found use, they still haven't even found the funds to finish a second one which is partially built.

When this option is needed today, helicopters are deployed on cargo aircraft to the area. The helicopters may have to make multiple trips but can do the job. So the subset of cases is even smaller; where heavy cargo needs to be delivered to a remote area and also cannot be split into shipments that helicopters can handle. Deploying a large airship in this manner is also much harder. Either the airship would have to fly itself there, which could take a long time, or it would have to be reduced to a transportable size.

The airship would also need to be protected from the weather somehow. This could require either a very large (and expensive) hangar. Without a hangar, the airship must be tethered, and restraining such a large surface area in the wind would be difficult.

Wind would also affect operation of the airship. Helicopters are of course limited by weather conditions, but wind would have a much greater effect on a large and slow airship.

If the airship could be fairly easily collapsible, it would solve the issues of storage and transportation. However, this is not a simple problem to solve. This would require a large development budget. If you are comparing this to the cost of the 787 development, where are you going to find buyers for 1000 of these airships in order to break even and make them affordable?

The issue is that there needs to be a market for this kind of transportation, which currently competes at least partially with existing helicopters. Why invest in a new type of vehicle when the current option works fine for most cases?