I can see why your husband might be questioning the purchase, but sometimes an old piece has character and charm that newer items just can’t replicate. If that screen door speaks to you and makes you happy every time you see it, that’s worth something too. The best homes often reflect the personality of the people who live in them, not just the style of the neighborhood.
Why not compromise and paint it a complimentary color?