Biden needs to be publicly excommunicated and denied the sacraments. However, the US Bishops don’t have the stomach to bring excommunication. I remember Ted Kennedy was given a full Catholic burial with a bishop presiding at his funeral despite his staunch support for abortion.
The problem with that is it violates the separation of church and state.
When Kennedy was running in the 50s, various groups claimed that the Pope would hold excommunication over his head to force Kennedy to do the Pope’s bidding.