You will always need somewhere to stay, so you will always be in the position of paying rent or a mortgage.
It's a tricky decision these days.
In the past you could feel fairly secure that you would get back what you paid for the house (and more) and that renting was 'dead money'. You'd have finished paying for it by the time you retired. It was a fairly easy decision, as long as you could secure a mortgage.
Currently, prices are so high compared to wages that you feel it must be a bubble and the market should correct itself, which would leave anyone who bought at the top of the market in negative equity. However - I've thought this for at least 15 years now, so what do I know? Nowt. I don't know how anyone can afford to get on the property ladder these days.
As for the rental market - council housing is all but extinct and many private landlords are amateurs who think their property is nothing but a cash cow and why should they spend their money on maintaining the fabric of the building? If they decide they're tired of being a landlord they can sell the property from under you and give you notice to leave, no matter how good a tenant you have been. There's very little security in renting, I've read too many despairing threads on MN in the last year or so where families are constantly have to up sticks and move again due to the vagaries of the rental market.
"I want to buy a house again but my husband thinks we should forget it and just enjoy life and save for the future! Such as invest more into our pensions."
I have some sympathy for your husband's take on it, you say you've had a rough year and maybe he wants to draw breath before (if?) shouldering a "ridiculously high" mortgage.
But I'm cautious, and I'd be worried about how I'd meet the rent once I retired, regardless of how much I'd invested in pensions. I think you need to properly explore your options, work the figures and consider what the future might bring. Nothing more constant than change, and you need to consider what changes might happen in the housing market, and how you'd be able to adapt to those changes.
And you shouldn't feel embarrassed, you've dusted yourself off and got back on your feet. That's pretty damned positive in my book!