The enchanted land loses its existing land types and any abilities printed on it. It now has the land type Swamp and has the ability to tap to add to its controller's mana pool. Contaminated Ground doesn't change the enchanted land's name or whether it's legendary, basic, or snow.

Contaminated Ground's last ability triggers whenever the enchanted land becomes tapped for any reason, not just when it's tapped for mana.

If, while casting a spell or activating an ability, the enchanted land's controller taps the land for mana to pay for it, Contaminated Ground's ability triggers and goes on the stack on top of that spell or ability. Contaminated Ground's ability will resolve first.

On the other hand, the enchanted land's controller may tap the land for mana, let Contaminated Ground's ability trigger and go on the stack, then spend that mana to cast an instant or activate an ability in response. In that case, that instant or ability will resolve first.