Brad Pitt spotted drinking at Taylor Swift and Travis Kelce’s wedding in July before publicly admitting he is off the wagon