Where are you located? I am used to USA brands that might not be sold in UK or EU. Do you prefer the self inflating pads that have internal foam, or the air mattress pads that are more compact to pack but thicker in use?
I preferred a REI branded one (only sold in USA) air mattress, but I had two of the REI ones fail, no more REI ones for me. It had internal baffles that quit being baffles, which I am guessing is what happened to yours because I remember hearing the pop. See photo. I do not know if I over-inflated mine to cause the fail or not. But I now intentionally put less air in them so they are less likely to be over-pressurized. That said, I had less air in the second one when it failed. Perhaps it had some material that failed due to age, as some plastics appear to do.
I have a Neo Air XLite air mattress that I have used on some trips, I only bought it for trips where I wanted the lightest amount of weight and I got it at a very good discount. It was very noisy at first. I think there was an internal thermal barrier that was very noisy when it was flexed, but after several weeks it seemed to get quieter. So, if you get one and do not like the noise, it gets better fairly quickly.
After having two REI air mattresses fail, I decided to buy a spare of another brand when I saw a really great price on a one on sale. I have not yet slept on it, this one has no internal insulation so it could be cold on cold ground, price even at full price is not bad, this is my spare:
https://klymit.com/products/static-v-camping-sleeping-padI used to use the self inflating pads. I like them too, but they consume much more space when packed, even when I always bought the shorty versions. So, for bike touring where my pannier volume is a key factor, I use air mattresses. I think the self inflating pads with some internal foam are much better on cold ground. And if it leaks, it still gives you a tiny bit more cushion than a deflated air mattress. And when backpacking, I can strap the self inflating ones on the outside of my pack. Second photo.