On any particular day I can be optimistic, energized, discouraged or pessimistic on the state of the church. It largely depends on churches that I am working with at the time.
The New Testament shares such sentiments with Paul writing to the Corinthians (they had a lot of problems) or the Ephesians (they seemed pretty healthy) or the letters of Jesus to the churches in Revelation three (a mixed bag).
Many today are giving up on the church and simply leaving or choosing to stay home. I sympathize and empathize. There are a lot of unhealthy churches. Healthy and vital churches are vastly outnumbered by unhealthy or problematic churches.
But: regardless of our analysis, the local church is God's chosen instrument to reach the world as the local manifestation of his universal church made up of those who are his children. That is why I will never give up on the church and why I will never stop trying to help the church and why I will devote my life to multiplying healthy churches among all people.
It is frankly amazing to me that the church is as resilient as it is. That is not a testimony to man but to the power of the Holy Spirit who is present in small, large, poor, wealthy, underground and above ground churches. It is His church and the forces of hell will never prevail against it.
The church is flawed because it is led and attended by flawed people. The church is powerful even with flawed people when empowered by the Holy Spirit who powerfully changes lives and empowers people for meaningful ministry and brings life change.
The church is His bride and He loves it and died for it. Given that I will never abandon it or cease to help it be all that it can be. As long as Jesus believes in His church, I will too.