It might depend on how you define "failed" . Tesla defines failed as being down to 70% of original capacity. It seems 250,000 or even 400,000 miles is possible on many Teslas before loss of 70% capacity.
Loss of battery capacity is fairly rapid initially and then very slow after that. If you defined "failed" as being down to 50% of original capacity current EV batteries would go a very long way. Even so 1,500,000 km (937,000 miles) would be quite an accomplishment.
Meanwhile we need to be realistic about expectations. Not many of us put extreme miles on a vehicle. And not many vehicles ever see extreme miles. There are other limits to vehicle life - rust, crashes, interior wear out, accumulated small stuff.
Our family has had 2 vehicles at all times for the past 50 years. The newer vehicle gets driven the most and the older vehicle much less so. The most we have ever put on a vehicle was 285,000 km (178,000 miles in 18 1/2 years from new). We've had other vehicles to an older age (21 years) though not as many km. So a current Tesla battery should last as long as we would ever need.