A bed mattress is too soft if it droops, or if a 2nd individual in the bed causes the other to dip towards the center.
Many homes are not designed to take the weight of a waterbed in one location.