There’s generally just 2 types, sodium and mercury, not including LED!
Sodium comes in low pressure (SO, SOI, SOX and SLI), and high pressure (NAV, HPS, SON, LUCALOX)
Mercury also comes in low/medium pressure (Fluorescent MCFE, PL, MA), and high pressure (MB, MBF HQL, HPL), and then mercury halide/metal halide (MBI, HPI, HIT, HQI).
It’s just the nomenclature that’s confusing!
Have a read of Lamptech in the links section, everything you ever needed to know is there!