Does Shiny do anything to help if the data source is too large to load into browser memory?

No, Shiny doesn’t change R’s capabilities. However, there are techniques for only sending the data down to the browser that a user needs to interact with and keeping it mostly on the server. After all the front end is just HTML/JavaScript and CSS.