How do I unhide all objects just on my current active collection?
In the collections panel, there is an icon that looks like a funnel. This is the Filter drop-down. Click that and activate the eye and the screen icon if either are unseen. Provided both are visible now, shift-click the eye icon twice and the screen icon twice, corresponding to the top level of your collection. This will ensure that everything contained in that selection will be shown.