Just like abortion, the current SCOTUS will rule it is a state issue, and the veto override will stand.
Not the best outcome but probably the best we can hope for.