How does long term alcohol or drug use cause mental retardation?

Not quite the same. The term mental retardation is an old term that refers to brain problems present at birth or in early development. Alcohol and drug use can and do cause a loss of cognitive function in adults. Alcohol kills brain cells; some drugs deplete certain neurotransmitters.