in recipes like penne alla vodka, it helps the sauce become a creamier, tomato-ier, more cohesive whole. you could use wine or other alcohols that would impart their own distinctive flavors, but in a rich sauce like that it's not entirely necessary.