I have done these types of calculations myself. You can see here: https://nextjournal.com/erik-engheim/renewable-energy-calculations/

I can unfortunately not easily follow your calculatiosn because you are using all these odd American units ;-) Got to be metric or it is all gobbledygok for me.

What I have primarily looked at is electric production, and I suspect you get your numbers by looking at ANY kind of energy usage. However I don't think that is fair.

Electricity is a higher order form of energy. E.g. you can use electricity to drive a heath pump at get 4W of heath out from every 1W of electricity put in.

Or if you need to simply heat up water or a building you don't need to use solar cells. You can use simpler more effective solar solutions capturing clost to 100% of the energy from the sun.

Likewise if you use biomass to serve an energy need , that is far more efficient if your energy need is simply heat.

Also keep in mind that lots of existing energy infrastructure can be used. Just because we use wind and solar doesn't mean we will be closing down hydro power plants or existing nuclear power plants.

A lot of energy is spent powering cars, but keep in mind that this is done extremely inefficiently with an internal combustion engine. An electric motor is far more efficient. Thus the energy spent moving cars and trucks around today is much more than will be required to move an electric car around.

In short, simply looking at total energy use is deceptive. The best starting point is electric power usage today.

A huge amount of energy is spent for heating and this should be calculated far more in detail. E.g. we should look at the extend heat pumps, geothermal and biosmass can be used for this. Using electricity as-is would not be smart.