There are infinitely many non-zero probabilities of success. Since the zero probabilities are irrelevant, and you will always eventually reach all the non-zero probabilities, consider only these non-zero probabilities of success and write them as a sequence: $\ \{p_i\}_{i\in\mathbb{N}};\ 0<p_i<1\ \forall i$.
Then, the probability of at least one success equals $$\ 1- \text{P(no successes)}\ = 1- \displaystyle\lim_{n\to\infty}\prod_{i=1}^n (1-p_i);\quad (0<p_i<1\ \forall i)$$
As Peter alluded to in the comments, the limit $\ \displaystyle\lim_{n\to\infty}\prod_{i=1}^n (1-p_i)\ $ converges to a non-zero number if $\ p_i\ $ are fast decaying/converging to zero. The only number $\ \displaystyle\lim_{n\to\infty}\prod_{i=1}^n (1-p_i)\ $ cannot be is $\ 1,\ $ because $\ 0<p_i<1\ \forall i.$
Therefore, the probability of at least one success could be any number strictly greater than $\ 0\ $ and $\leq 1.$ It all depends on what the $\ p_i\ $ are.
An easy way to see that the infinite product of numbers between $0$ and $1$ could result in a number $\ \geq0\ $ but $\ <1\ $ is the following. For any $\ u>0,\ \varepsilon>0,$
$$ u-\varepsilon = u\left( 1-\frac{\varepsilon}{u} \right)$$
In other words, taking away by a small amount $\ \varepsilon\ $ is the same as multiplying by a number just less than $\ 1\ $ (there always exists such a number and this number is $\ 1-\frac{\varepsilon}{u}).$ So our infinite product is really just some decreasing sequence.