UPDATE:
Today I picked up my Model Y with the pumps replaced, and despite the noise being almost gone, it is still there. Much better though, and it is in a "tolerable" range. I couldn't get upset this time. The technician who took care of my problem since June knows this problem very well and could not do anything more to help, but yet, he was very kind to explain that the reality is Tesla has no idea what is causing this problem. They could keep replacing the pumps with the hope the noise will disappear, but there is no guarantee. I spoke to him for almost one hour today, asking him if there isn't really anything else they can do to fix the problem, and he said not as far as he knows. This is the topmost level this issue can be brought up to which is the replacement of the pumps after opening an engineering ticket.
I am really getting tired of fighting for this, and I am thinking of either accepting the problem or ordering a new Model Y and reselling this one.
At this point, I am afraid the petition I started on modelyissue.com is going to bring us anywhere either. I'll keep collecting signatures and, when 100 is reached, I'll submit it, but I have not much hope in it.
I'll keep following and leading this story as much as I can, eager to learn from other people's experiences.
Thank you again for following and contributing.
PS: By the way, the part they replaced are two pumps #1133851-00-G as you can see from the shot below: