I’ve never done anything like this, but would it be possible to place such a sensor between the mattress and the frame instead? That would result in a fraction of the load due to the distribution of the weight. The challenge would be to set the threshold right.