This hasn't been proven to be the case at any meaningful scale yet so is very much a 'might' instead of a 'will'.
Edit - as for home storage... There is such an obvious solution to this which is already in the pipeline. Vehicle to home and vehicle to grid. Why stick half a decade old Tesla to your wall when you can just send power to and from the car you drive every day? It'll almost definitely have way more capacity and has the added benefit of being replaced with the car.
The counter 'fact check' to Rowan's article said that EV batteries didn't contain rare earth materials so it seems that argument gets spun whichever way suits! As for the rest of the materials, yes they have value but what will the cost be to A) get them out and B) deal with the rest of the waste in an acceptable way? If A+B doesn't significantly undercut the value of those materials then it makes that business model a hard sell.
Honestly, if I had to put money on how I think this industry will pan out, it will be levied back on to the manufacturers to deal with the problem of EoL batteries and that any talk of them being a proverbial pot of gold that companies can't wait to snap up never coming to fruition.
Although even that prediction doesn't hold up when we accept the innevitable fact that we will only be able to buy something from Geely or direct from the Chinese state by the time scrap EVs become an issue