Democratic presidential nominee Kamala Harris and running mate Tim Walz gave pep talks to campaign volunteers and a high school football team Sunday