Biden cannot override a SCOTUS ruling. He can try to pass federal legislation establishing codified abortion rights into law, though. That will mean getting rid of the filibuster to pass it in the Senate. Manchin and Sinema stand in the way of that.