Is my heater core defective if the inside of my car's windshield fogs up and I get a funny smell whenever I turn on the heater?

Yes. That smell is the coolant being blown into the air ducts. You might also notice a slimy film on the the glass that is very difficult to clean.