The joke is play on the phrase 'drift apart'.  When used in describing a relationship, 'drift apart' generally means that the love between the people is fading.  They have a water bed, and in water one could drift away from somebody else just by a current or force in the water, or simply laying in the water and drifting.
When they bought a water bed , the couple started to drift apart .