IMO, this won't work.
Water is likely going to severely dampen any vibration that would otherwise occur from the tactile transducers.
As well, most tactile transducers are very much designed for bass reproduction, not full-range audio reproduction. There ARE full range tactile transducers available to be purchased, and they can be mounted on all types of surfaces. You certainly can mount them on the waterbed just fine, but my expectation is you will have very little luck with the final result.
All tactile transducers will need a separate amplifier designed to work with them as well. So, read and do some research on things first. You will want to reach out to manufacturers if you can to see how they work with full range audio.