I think that space mining will not be profitable in the near future. For several reasons: the first is certainly that it is still extremely expensive to carry out such missions at the moment. Also, the chance of something going wrong is very high, so the potential risk-profit ratio is far too high. In addition, resource prices on Earth would have to be much higher than they are now. Another important factor is that many resources that are rather rare on Earth (gold, platinium, uranium, etc.) are much more abundant in space. If more of these are brought to Earth now, the price will collapse, which in turn will mean that mining in space will no longer be worthwhile.
In other words, the current price of raw materials will have to increase x-fold for mining in space to be worthwhile at all. And since global economic growth is slowing down anyway, it will be a long time before we reach that point.
No one claims that the extraction of natural valuable minerals in near space can happen in the near future. The appropriate technology for this does not even exist yet. But all this will arise over time. Humanity simply cannot do without their space production. And this is absolutely nothing to be afraid of. If, as a result, there are much more of certain valuable metals such as gold and platinum on our planet, there will simply be a revaluation of values. Yes, there will be price shocks for some time, but in general for industry, the development of equipment and technology, this will be an unprecedented rise.
Mining in space will always be meaningful and promising as human knowledge expands and we learn more and more about new chemical elements and their beneficial properties. As a result of this, our capabilities will expand, and this in turn will have a positive impact on the possibility of deep space exploration.