Night & Day Cube w/ Pocket Coil Mattress

I'm looking to upgrade my 10+ year old Ikea bed frame and 10in spring mattress to something more compact for a small living space. I researched Murphy beds but unsure about drilling into the wall because I'm not the handiest person. Recommendations welcome though.

Anyway, I am able to secure the Cube with Pocket Coil mattress for $1650 + tax. Since I've only slept on spring mattresses, I'm not sure if a 6in mattress will be comfortable for me. And I don't want to spend so much money on something that may or may not work.

I'm 225lbs and 5'7". Mostly a side and stomach sleeper.

Any thoughts are welcome!