Mikuma
Presumably the lack of AP or SAP bombs is why she absorbed so many bomb hits?
She didn't absorb that many bomb hits. The photo shows the accumulated damage from the bomb hits and from other damage.
Mogami collided with Mikuma on the evening of 5th June at 28knots. The former saw her bow crumpled back to No 1 turret leaving the ship some 40ft shorter. Mikuma was luckier as it was more of a glancing blow for her. But it left her with stove in plating mostly above the waterline port side and a leaking oil tank abreast No 4 engine room due to a 20m long, 6m wide gash.
On 6th June the pair and their 3 escorting destroyers were discovered by the USN and strikes organised:-
0800 Hornet launched 25 SBD (8 with 500lb & 17 with 1,000lb) and 8 F4F Wildcats. 2 aircraft lost to AA. Results were one near miss on Mikuma and 2 hits on Mogami (one hit No 5 turret destroying it and the other smashed through the aircraft deck and started fires on the torpedo deck under it. Fires were out in 1 hour).
About 1045 Enterprise launched a strike of 31 SBD and 12 F4F Wildcats with 3 TBD Devastators being added at the last minute (which were ordered not to attack if AA fire was too heavy and so didn't). Results were:-
2 hits on Mogami - one on the aircraft deck and one forward of the bridge inflicted medium damage.
1 hit on Mikuma No 3 turret destroying it.
2 more bombs hit Mikuma's aircraft deck and tore down into the port aft engine room (it later became apparent her hull bottom was holed in this area) and started a huge fire in the area of the torpedo tubes.
At this point she also suffered another 2 hits and at least 2 near misses and was slowed to a standstill.
Nearly two hours after the attackers left, the fires amidships on Mikuma reached her torpedoes, a number of which exploded. She carried 12 of the 24in Long Lance Type 93 torpedoes each with a warhead containing 1,080lb of explosive (that is nearly double the explosive charge of the 1,000lb HE bombs used on her). Her entire upperworks from the funnel to the No4 turret were reduced to a pile of tangled metal by this explosion, which also felled her mainmast. In the photo you can see the torpedo tubes themselves hanging out of the hull due to the force of the explosion. Until that point the captain of Mogami believed that Mikuma might be salvageable if he could get a towline aboard.
At 1345 Hornet launched another strike of 23 SBD with 1,000lb bombs. They reached the IJN ships around 1500 and achieved just 3 hits. One on Mikuma, one on Mogami & one on the escorting destroyer Arashio.
The hit on Mogami was again on the aircraft deck that was already damaged by earlier hits and started a horrendous fire and caused difficult decisions to be made to stop it spreading and let damage control get a grip on it.
Not sure where that final hit was on Mikuma. Somewhere down the line damage caused an internal explosion in No 2 turret, blowing its roof off. But she lingered on the surface until finally sinking around 1930, some four and a half hours after the last attack.
The photo you posted was one a a very famous sequence taken by two SBD crews from the Enterprise sent to settle the issue of whether it had been two cruisers the USN had been attacking or a cruiser and a battleship. I suspect that with her damaged bow pushing a huge bow wave, it would have been easy to mis-identify Mogami for a much larger vessel. Unfortunately aviators of all nations have never proved to be much good at ship identification!
So overall with most probably being 1,000lb
Mogami - 5 hits
Mikuma - 6 hits
Plus of course the near misses on both vessels.
But ultimately,as has been pointed out, ships sink when water gets into the hull. Most of the damage to both Mikuma & Mogami was above the waterline. What underwater damage there was to Mikuma was only allowing the relatively slow ingress of water so she stayed afloat for a long time.