That the probability goes to 1 as N goes to infinity FOR FIXED p is just another example of assuming p can't be "too small". The probability also goes to zero as p goes to zero. Why are you fixing p and not N? Why are you assuming p is large enough that N is in that asymptotic range where the probability has approached 1?
Furthermore, proponents of an extraterrestrial origin of life on Earth will doubtless argue that nearby life may have had a common origin.
However, if we found life on Mars that same Bayesian reasoning would imply a meaningful lower limit on p as well, since life on Mars is independent of our existence to observe it.
Just finding life on Mars that's the same kind of life as on Earth would not tell us much, as it could be explained by panspermia. There are Mars rocks on Earth, so transfer of life in those rocks should have happened constantly. If early Mars were habitable it almost certainly had life, due to this transfer.
If we found life on Mars tomorrow, how well-defined would that lower limit become?
What we want is the probability for at least one other place other than ours to have life. This would be 1 - (1-p)^N, which does tend to 1 as N gets arbitrarily large.
To get that formula: (1-p) is the probability that life does not exist in a place, so (1-p)^N is the probability that ALL places where life is possible, has no life. Therefore, 1-(1-p)^N is the probability of the opposite of that (where at least one place has life).