The usual understanding of the quote assumes that Marx considered opiates a bad thing. I don't know whether he did or not. In any case, tame religion does pretty much the same things to a population that opiates do to organisms.
* the word "tame" is a reference to Narnia, as in "not a tame lion".