My ~15 year old blog has, according to Google Search Console, 15 indexed pages, and 174 ‘Discovered - currently not indexed’ pages. The number of indexed pages is going _down_ over time, despite occasional new posts.
The Search Console page says “Examine the issues […] to decide whether you need to fix these URLs.” But about the only suggestion I can find is just to wait for them to be indexed - which doesn’t seem to ever happen.
I wouldn’t argue my blog is the best or most exciting content in the world or anything, but I can’t believe anyone would say it’s worse than the often-incorrect SEO-informed duplicative nonsense that fills the first few pages of Google search results for anything technical nowadays.