Hi sarah and welcome
Different folks have different preferences and budgets.
I struggled for ages with blow up mattress until I found self inflating mats. I went for comfy too, with a therma-rest dreamtime which is like sleeping in my bed at home. here Other people prefer the cheaper airic mats here
Some use mats on top of a camping bed frame.
The design of blow ups have improved apparently but I won't trust them again, got sick of waking up on the cold floor.
Good luck
Amazing family weekend with old steam engines, classic car displays, market stalls, and full catering and bar. And camping on site - Save £25 by booking in advance.