Does that mean that signing the card is effectively the same as voting for the union in an election?

Yes. If the union submits enough cards (50%+1), then there will be no election and the Union would be legally certified as exclusive representative for all employees in the bargaining unit. There would be no opportunity to vote.