is fascinating that a software developer can have such a lack of awareness of the relative size of things

Why? Software developers aren't some superhumans, we're generally very bad at things outside our immediate area of expertise. Just like everyone else