The law is working exactly as intended. The copyright lobby is very powerful. If you look at the legislation being proposed since 2010, it has primarily been to strengthen the DMCA. Though Google, Reddit, Meta, Wikipedia, etc. were successful in organizing opposition to these bills, they have no incentive to lobby for the repeal of the DMCA.