The capacity of the Three Gorges Dam is 39.3 km3, or 39.3 × 109 m3. One cubic meter of water has a mass of 1 tonne, so the capacity of the dam is 39.3 billion tonnes of water (billion as recognized in the USA). From here onward I use billion as it is used in the USA, 1 followed by nine zeros (109).
The Three Gorges Dam is situated in one small location, relatively speaking. Mine production occurs at various locations around the world, so there will be a countering affect because of this.
Considering the mining aspect, the two main commodities that are mined in bulk quantities are iron ore and coal. The total world annual production of iron ore is 2.5 billion tonnes. The total annual amount of coal mined is 7.7416 billion tonnes.
Combined with iron ore production, that amounts to 10.2416 billion tonnes of iron ore and coal in one year. This is 26 percent the capacity of the Three Gorges Dam.
The total amount of crude oil produced in the world in 2021 was 77,043,680 barrels per day, which is 28.1396 billion barrels, or 4.476 billion cubic meters for that year. Taking a density for crude oil as 900 kg/m3 (0.9 t/m3), this equates to 4.0284 billion tonnes of crude oil.
Add this to the amounts for iron ore and coal and the total is 14.27 billion tonnes extracted in one year. This amounts to 36.3 percent of the capacity of the Three Gorges Dam.
As mentioned previously, the Three Gorges Dam is located in relatively small area of the world. Mine and oil extraction occurs around the planet. There will be an effect from such mining and oil extraction activities, but the effect will be much less.