That’s not how reasonable accommodation works under ADA. If you were applying for a job that required you to be in office they could just refuse to hire.
It's what it is, and I would have no choice but to keep looking. Fortunately companies and employers are not a monolith, and some are more reasonable than others regarding things like this and may not challenge it. Particularly if you have in-demand skills.
could utilize public transportation.
This would certainly be a viable in some parts of the U.S. Indeed, loss of vision would very likely push me to relocate to somewhere with better accessibility for non-drivers.
Despite my misgivings regarding their technological viability, this is one of many reasons why I am a big promoter of self-driving vehicles. But I still think working models available to consumers are a minimum decade or more off.
TIL that this wedding that I heard about quite a while ago hasn't actually happened yet. The context of the news story on it was how outrageously expensive it is.