This also comes down to enforcement. Even if a federal mandate were somehow passed, if the people's hearts aren't in it in red areas, cops won't enforce it in those areas and it will be a joke. It really is 100% about public opinion.
To your point though, I'm pretty extreme left, and I don't think we are going to have an easy time containing it by any means. It is going to continue to rise months and possibly years into a Biden administration, but I think we'll still have a lot less deaths. No one on the left thinks this is magically going away, even with a vaccine. Distribution and production of a vaccine is incredibly difficult logistically, and these things need to be refrigerated. So at best we're looking at like a year from now we all get a vaccine imo.