Revisiting the vector leptoquark explanation of the B-physics anomalies