Do they reveal the crime in the intro like Poker Face?

Yes, the intros show who the perpetrator is, how the crime was committed, and what the motive was. The rest of the episode is the audience seeing how Columbo will figure these things out.