I have resolved it.
So the deal was with the mode of weight map import, it was set to “Loaded only”, and you need to set it to All to make water finally appear
