The short answer is no, unless you vote for them because they are pro-abortion. If you vote for someone because they are pro-abortion, then, yes, you would need to go to confession. However, voting for someone who publicly supports greater access to abortion and increased funding for places that perform abortions seems inconsistent to our Catholic faith.