Here is the updated data, correcting the data for Yorktown.
US Aircraft-carrier Hardness
Source: Wikipedia
Ship sunk, damage taken, lbs explosive
Lexington (CV-2), 2 torpedoes and 3 bombs, 3503 lbs
Yorktown (CV-5), 2 torpedoes and 3 bombs, 3503 lbs
Wasp (CV-7), 2 sub torpedoes, 1786 lbs
Hornet (CV-8), 3 torpedoes and 5 bombs, 5530 lbs
This assumes a bomb hit is 551 lbs (usual for D3A), a torp hit is 925 lbs (assuming largest-warhead type 91 for B5N), and a sub torp hit is 893 lbs (type 95).
Average lbs taken to sink is thus 3580 lbs.
Carriers that weren't sunk, where ";" is used to denote separate attacks, in between which there is perhaps some or even a lot of repair.
Saratoga (CV-3), 6 bombs
Enterprise (CV-6), 3 bombs; 2 bombs; kamikaze
Essex (CV-9), kamikaze
Yorktown (CV-10), bomb
Intrepid (CV-11), torpedo; kamikaze; kamikaze
Franklin (CV-13), Kamikaze; bomb; kamikaze