Does it look bad if letter of recommendation comes from an emeritus professor?

The best reference is the one that is both honest and based on extensive firsthand knowledge of your qualities. Emeritus status would seem irrelevant to me.