Coerce None according to the dtype of the container

Fixes #7939
I'll update it to use `self.is_numeric`.

Datetime is already coercing, so I didn't change the behaviour there. I just wanted to ensure this behaviour was tested.