You’re going to need a bit of software..
Something to drive the cellular shield, to establish the data connection, then as you suggest, a second (ESP) or similar to create a 2.4G WiFi hotspot, and finally some code to register the clients / connections and pull it all together.
Personally, although I could do it, I’d be buying a retail cellular hotspot with all the features it offers. I’d guess in Australia that will be about $120-150 plus data plan.
Forget about GSM, for data that’s almost irrelevant, even 3G is scheduled or shutdown in some regions.
If you’re designing new gear, it has to be 4G or better - the SIM-7600 family is what I now use for 4G cellular projects.