A Low Air Loss Mattress is much better. My wife uses one and her doctor that treated her pressure sores recommended it. They do cost more. Some insurers will pay some want and if the person is Diabetic I understand it makes the approval process easier. My wife uses one due to quadriplegia. They are roughly $1000. But they save thousands of dollars in doctor bills. One pressure sore treatment can run in the thousands of dollars real fast.
i don't know from long term, my Mom was terminal and didn't last three months and the one we had was much better than not having one... but this was 25 years ago so i hope things have improved since then i hope the best for you and your wife, prayers up