Can a duplicate seed / passphrase be generated for any address by wallets in any means?
If yes, what's the possibility of it being done, I mean in how much time addresses' seeds and passphrases may go stagnant if ever?
Theoretically, yes. Private keys could be generated "a second time". This is called address collision.
There are 2^160 possible addresses which can be generated. Since, in theory, you have to search 1/2 of the search space to find a collision (birthday paradox),
you would need to calculate 2^159 priv-/pubkey pairs, on average, to find a collision by an address being generated a second time.
2^159 = 7307508200000000000000000000000000000000000000000000000
So the chances of a collision are almost zero. It is considered to be "bullet proof"
Provided the wallet you are using is using a good random number generator (with enough entropy).