There is not "just as much" bipartisan support for voting no. Using simple math, that's 24 out of 100. But I would guess, given the open public pressure not to pass it for political reasons, that number will grow on the Republican side.
As to the text of the bill, which is by definition a compromise between the two parties, that means obviously there are things in there you won't like and things in there I won't like. That's what a compromise is.
As to the actual parts of the bill, the people who are charged with actually doing the border enforcement say it's a good (but not perfect) thing, and THEY want it to pass. Stop trying to shift the argument. This is just another case of Republicans catching the car and not knowing what to do or liking it, just like the abortion debate. For months and as recently as December, they screamed that any additional support for Ukraine would have to be tied to border reform. They obviously thought Democrats would never go for it, and now they have, and they're just refusing to go ahead for openly political reasons. That may play well for the full on MAGA heads, but not with the normal people/independents, who WANT both parties to work together and compromise.