Approximately only 5% Bitcoins are left to be mined. Is it good or bad?

As only 5% left to be mined, will it drive small miners away and reduce the mining activity? Maybe the mining activities will be limited to big corporations.

Cos even those 5% remaining bitcoins will take more than 100 years to get mined based on the block reward patterns and how they will keep getting halved after every 4 years,

Some say mining activities wil not be impacted but i find it hard to comprehend the scenario that happens… cos would they still be in business if its not profitable?