Is it normal for water to drip out of the bottom of the heater core housing or do you have a leak?

No, it's not normal. You have a leak in the heater core or may just be connections to heater core. If left untreated, it will soak into your rug and eventually cause your floor to rot.