The COVID vaccines reduce the risk of infection by a factor of 4 and the risk of serious disease by a factor of over 100. You’re right that vaccinated people still get COVID but the vaccines do a very good (if not quite perfect) job of protecting people and stopping spread to others.