Typically, at least in the North, mango pickle is made with green small desi mangoes which are rather sour.

I haven’t seen those in the US. The only green mangoes I’ve seen are rather bland and not sour enough.