Superstar delivered an emotional speech at Kamala Harris’s Houston rally