The most effective way to not transmit is to not get infected in the first place. The vaccines drastically reduce chance of infection.
> For example, this is what you're study says:
>> The mRNA vaccines are highly effective at preventing symptomatic and severe COVID-19 associated with B.1.617.2 infection
The very next sentence states,
> Vaccination is associated with faster decline in viral RNA load and a robust serological response.
This means that infections in vaccinated people are typically much shorter-lived than infections in unvaccinated people. The time during which you have high viral load is drastically reduced.
> it's possible that vaccinated individuals were simply practicing better viral hygiene
Reducing infections of family members by 40-50% is a massive effect, especially when you consider that the vast majority of people in this study had only even received their first dose. There's an obvious explanation that fits with everything else we know about vaccination (e.g., that vaccinated people who get infected are far less symptomatic and that the time during which they have high viral load is much shorter).
Most vaccines do not confer sterilizing immunity. Nevertheless, many of them still produce herd immunity. Immunity is not an all-or-nothing thing. You're far less likely to get infected if you're vaccinated, and if you do get infected, you're far less likely to transmit the virus. Even if you don't care about dramatically reducing your own risk of getting seriously ill or dying, the vaccine significantly reduces your chance of ever transmitting the virus to others.