It doesn't matter who the Alabama senator is, or from which party. The economy of the state benefits so disproportionally from the program that anyone who gets elected will find themself in support of it.

What matters is that Shelby is one of the most influential senators, because of his seniority and connections. Whoever replaces him won't have that, and the federal spigot to Alabama is going to be turned a lot lower for a while.