Pastor who tried to walk on water drowns