..the air pressure holds the tire wall out and it's the wall that supports the weight...
Not true for bike tyres which usually have very soft walls. Only slightly true for car tyres. Almost all the weight is supported by the air pressure acting through the contact patch, whose shape is constrained by the wheel rim. The bit of rim near the bottom flares out and applies more total force against that part of the tyre, and the increased reaction force at that part of the rim supports the weight (in simplified terms).
...If I keep adding weight, won't the tyre eventually burst? If so, what causes it to burst?
With enough weight, the rim pinching the tube/tyre against the ground causes the tyre to burst ("rim" or "snakebite" puncture) . Note that even "bottomed out", the rest of the tyre away from the contact patch is not deformed, therefore the volume of the tyre is not significantly changed.
I'm sure you'll be right, I'm just struggling a bit with the thinking...
Me too - every few years I get the pressure gauge out and measure the psi with me on and off the bike, just to check my sanity
![Big grin :biggrin: :biggrin:](/styles/default/xenforo/smls/biggrin.gif)
.