28% oppose the ban, and 32% support it. So a majority are either in favor or ambivalent. Two years ago a majority supported it: https://www.pewresearch.org/short-reads/2024/09/05/support-f...
Support has declined and opposition has increased. I don't think there's much of a disconnect here though, since it doesn't seem there are many people with strong opinions counter to what Congress chose to do.