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.