Compromise whether on his end or yours may be needed. Your confusion may stem from fear that you may not find something else, not wanting to lose what you've worked for, not wanting to part with your responsibilities especially if they are an ego booster besides offering a good monetary compensation.
Your husband may be feeling uncomfortable that you're earning more than he is at this moment.
Jobs and titles/roles change through life. When making a decision look at the bigger picture- what would benefit everyone in the family, what are the prospects that these jobs are "secure", what would the commute to work be elsewhere, what is living cost in a larger city, how are the schools/day cares, etc.
Change is constant in life. What people find security and comfort in does not necessarily last forever. When the priority is the family, how each partner is able to adjust and compromise to changes is going to remain vital to any decision that you undertake.