Should the relationship be over when your boyfriend says he will never get engaged?

No. Nothing has changed in your relationship except that he doesn't want to get married, lots of couples don't get married and grow old together.