You're being very kind. Many people in Congress know that their base is overwhelmingly against this, so the corrupt ones (the vast majority, especially any with good committee assignments) vote against it only if they're sure there's absolutely no chance of it failing. Whether or not they're currently in power doesn't matter. There's horsetrading even between parties to make sure donor/intelligence-supported bills will pass, but also to give people whose elections might depend on it the opportunity to vote against them.
The last thing that Republicans want is another America First libertarian troublemaker in Congress, and the last thing that Democrats want is some lecturing lefty. It's about business, not beliefs. Also, it's probably increasingly about blackmail.
When this math somehow fails (which happens every once and a while if somebody surprises them), it throws everything into chaos.
> Many people in Congress know that their base is overwhelmingly against this
I have learned that "overwhelmingly against" is a useless concept in politics. The important question is "do they care about it enough to sway their vote?"
There is probably overwhelming support for Ukraine to defend itself in the US (and Europe), but very few people are willing to change their vote based on Ukrainian interests over their own {financial security, culture war, pet issue (abortion, guns, Epstein List, etc)}. If it's not a top-5 issue, it's not relevant to a political campaign.
2A voters and rabid anti-choice voters are polarized enough to actually show up at the capital or threaten their representatives. Extremely few people will dot at for issues lower down the priority list.