so, guidance would be to look for an electret condenser? and ensure they can handle sound levels from around 120 dB to around 140 dB?
for context, i've tried these:
https://www.amazon.com/gp/product/B07VLMR2C3
https://www.amazon.com/gp/product/B074KJ1N3D
https://www.amazon.com/gp/product/B01F2IFYU0
https://www.amazon.com/gp/product/B088Z18CSL
without success while, as indicated in the OP, the mic here worked perfectly:
https://www.amazon.com/gp/product/B07SJ4XFTT
(and i assume it's not a special/high quality microphone as i paid $20 for the lot)