We are in cabin 1073 just behind 1074. I have been able to speak with the occupants of all the cabins around us. The only one who faintly hears it is across the corridor from us.
Unfortunately, my wife is super sensitive to the motion so our choice has been to remain in our current cabin. She loves cruising and we have been doing so for 25 years. Not including this cruise we have been on 39 cruises totalling nearly 500 days.
The Guest Services staff have been great in trying to assist us. We have even submitted very positive comment cards on their behalf. It's a rough situation but not one to get nasty about. If they come up with something fine, if not, also fine.
Interestingly we have gotten somewhat immune to it and it appears to have diminished some. If it is the piping as they say then maybe they are modifying their usage a little to alleviate sudden changes in flow. Since both my wife and I worked in Engineering all our career this has become a challenge to us to try and identify exactly the cause.