I think part of the problem in visualising this is that the soccer ball vs marble scale is wrong in every way.
With reference to
sun fact sheet and
solar system scale a 1m diameter sun would require a 9mm (small marble) earth with orbital radius 107.5m . The scaled masses are 734kg sun 2.2g earth.
Most graphical representations just don't show this relative scale, particularly with the mass which is very relevant when talking about gravity.
Michael.