Apparently 5 EPL teams will be able to qualify for the Champions League next season through league position. This had something to do with West Ham eliminating Freiburg in Europa League, which boosted England's coefficient rank and moved them above Germany, meaning EPL will earn an additional UCL spot.
This is explained in this article:
https://www.skysports.com/football/news/11095/12940385/five-champions-league-places-for-premier-league-how-extra-team-can-qualify-in-2024

So there's still some hope for Man United and Ten Hag.