I see three main downsides to the water bowl hide:

1) Once the snake gets a little larger, it can't ball up in the hide. It has to wrap around the bowl part.

2) The hide temp is greatly effected by the temp of the water in the bowl.

3) A larger snake will spill water or tip the bowl over when getting in and out of the hide.

As always, your mileage may vary