Can a bad one immediately turn a reader off? Absolutely. A bad prologue is one that is boring, does nothing to drive the story forward or give critical context, is too long, and/or is only used for an info dump.
Is a prologue a good idea for every story?