Corrosion inhibition compositions and associated methods for inhibiting corrosion on metallic substrates