The president was seen pulling out a wad of cash - which looked to be eight $20 bills - and putting it in the donation bucket for the church