So lets talk about the Drake Equation, the Fermi Paradox, and the Great Filter.
So the real problem with the Drake Equation is that we don't really know much about it. A lot can hide in those variables, and we don't even know if they are all the variables there are. There could be any number of completely unknown variables in there that makes the rest of them basically a rounding error.
The Drake Equation is a way to estimate the number of technological civilizations in the galaxy.
N = R* x Fp x Ne x Fl x Fi x Fc x L
N - number of detectable technological civilizations
R* - rate of star formation
Fp - fraction of stars systems with planets
Ne - avg number of planets per system that can support life
Fl - fraction of planets that develop life
Fi - fraction that develop intelligent life
Fc - fraction that develop a technological civilization
L - avg length of time the civilization is active
That could be REALLY bad for humanity.
It could be, but it could also be REALLY good for humanity. Honestly, if we accept the Drake Equation as it is, then it seems that the good is more probably then the bad.
Of the variables in the equation there are a few we have an idea of their value ( or at least we know enough to make some really rough guesses.)
Variables N, R*, Fp are all something we can guess at with some degree of accuracy, at least in our local galaxy.
Variables Ne, Fl, Fi, Fc we can't even make a guesstimate on as we have exactly one point of data for all these. All we can really say is that the number for each of them is greater than zero. That means that any or all of these could be the great limiter. The answer could end up being that life is out there, but it is so rare that it does not even occur once in every galaxy. This would be really good for humanity. We might have a galaxy, or even a galaxy cluster, to ourselves.
And finally, the variable everyone focuses on, the L. It could be also be a great limiter, or it might not. Once again we have basically no data on this. Like the others all we can say about this one is that it is not zero. So, we know exactly as much about it as the other 4 unknowns.
So that leaves 4 that are good, and one that is bad. Not terrible odds all things considered.
Those elements took several generations of star formation to create meaning we could be very early in the habitable portion of the universes timeline.
Very probably not. We know that complex life existed on this planet for about 400 million years before our civilization came about, they just didn't have the right situations for intelligence to form (that we know of). If we go by our civilization's advancement, then a civilization that has just a thousand year head start on us would be technologically godlike compared to us. With just our one example we know it could have happened up to 400 million years before us. So, even if we are 'early' in the 'habitable portion of the universes timeline' that timeline is still so vast compared to the speed that civilization advances that being 'early' is not significant. Once again, all based on our exactly one point of data. But that is the Drake Equation for you.
At any rate let’s hope we are passed the filter since our civilization is detectable in greater than 100 light year diameter sphere via our radio transmissions. Which suggests we might not have much time left before we, or someone, or something wipes us out.
That all matters on the exact value of those middle four variables. Four variables would have to work against us for that last one to matter, at least as far as the Dark Forest hypothesis goes.