It was a failure because it was an expensive program that produced nothing usable until after Germany no longer had the time or spare production capacity to produce a fleet of heavy bombers.  It should not take four or five years, with wartime experience, to produce a usable warplane.  The B-17 was only a little older, true, but in terms of wartime experience the Americans were far behind the Germans, yet the 1942 E and F models were entirely useable.  The British Halifax was usable out the gate and the Manchester failed (for the same basic reason as the He177s) until Avro and Rolls-Royce wisely stopped trying to make the overly complex Vultures work and just went with four Merlins to produce the immediately usable Lancaster.  Had Heinkel switched to a basic four engine He277 early on it would have been a great bomber, no doubt, but they persisted with trying to force a very difficult engine arrangement to work until it was too late for the resulting aircraft to be significantly useful.
The Do217 and Ju188 programs were much more successful in producing a usable bomber in a useful timeframe and for a reasonable cost.
I seem to recall it was a customer requirement that kept the He177 saddled with those engines.  If so, one can hardly blame Hienkel for the failure.  The Mitsubishi G4M 'Betty' suffered a similar fate, the customer insisted on two engines only when the manufacturer kept telling them they really needed four to get a usable warplane with the range being demanded.  As it is, Mitsubishi had to sacrifice all protection in order to get the range requested on a twin engined aircraft.