Experimental and numerical evaluation of foam physics in porous media across multiple scales