No, even by the time of Delta it was clear the efficacy against infection was marginal at best. The CDC acknowledged this in its Provincetown study in late July 2021 and recommended the reimposition of mask mandates as a result.
> data from this report are insufficient to draw conclusions about the effectiveness of COVID-19 vaccines against SARS-CoV-2, including the Delta variant, during this outbreak.
https://www.cdc.gov/mmwr/volumes/70/wr/mm7031e2.htm?s_cid=mm...