Judging by the sound delay, the explosion was likely up to 5 miles away. BBC interviewed locals, who claimed that the shock waves were so powerful they might have died if they were just outside. Zelenskyy's delusional war is suicidal, this must end
Target was most likely a large ammunition depot. Judging by the sheer amount, that was their storage for their entire spring counteroffensive. Welp.
Yet I have to wonder if it has actually achieved anything
Seems like OP is writing that it was really huge ammo stockpile, so yeah, now those ammo won't be shot at anyone and NATO would have to replace it first.
The wording in the title (vengeance for Crimea) implies it was known prior, but not attacked for some reason. And that it was the drone strike at Sevastopol that neccesiated this demolition.
As for "would have to replace it first" - they will. I've been waiting for NATO to run out of shells about as long as UA flag twitterati been waiting for Russia to run out of missiles. Donetsk is still getting shelled, people still die. Russian aviation is now using KAB bombs, even losing one over Bryansk. The war still doesn't appear to be any closer to conclusion, Nazis are still out there, dancing on the bones of the slain. And China is now offering peace! To zelensky personally!