It definitely reduces infection risk and transmission risk substantially, even against Delta, and still mostly eliminates hospitalization (which puts health care workers and people who need urgent medical care at risk) and death.
We don't have solid data on whether vaccination substantially reduces transmission risk. It's possible but remains unproven. The vaccines are still very effective at preventing deaths.