To be able to load data into and to see what data is stored within a GeoPackage, you first need to make a connection to it.
In the Browser panel tab, right-click on GeoPackage and choose New Connection. Navigate to where the new_sites.gpkg GeoPackage is stored.
Once connected, you can expand the GeoPackage and see the layers and tables stored within it.