After church initially distanced itself from former Trump aide's event, video subsequently emerged of pastor greeting the rally at its outset, spurring stronger apology