It's true that you don't know what the future holds. A lot can change in 10 years, a lot can change in just one or two years. But, I would never recommend staying in a relationship and "hoping" things will change. I tell anyone in a similar situation that you have to love your partner as they are now. You should not love a future idealized version of your partner.

If it were something small that you could just say "agree to disagree" and move on with your lives that's fine. But this under most circumstances would be a deal breaker. Find a way for your partner to understand or find someone else who will.