The only H5P integration that features to automatically install and update all H5P libraries that are featured on the H5P Hub server is moodle’s custom H5P integration in moodle’s core.
When using the H5P plugin for WordPress (or any other H5P integration except the one mentioned above), the most feasible way is to use the H5P Hub and start installing the compound content types such as Column, Course Presentation or Interactive Videos first, because installing them will also install libraries required for their subcontent types.
Please note that this will not cover “all” H5P libraries, as there’s a substantial amount of content types that is not featured on the H5P Hub Server yet (including Agamotto 1.6 that you installed earlier today, the H5P Hub server still serves version 1.5). You can find some of those content types via https://www.olivertacke.de/labs/h5p-content-types/. The most convenient way to install those content types is by obtaining a content file and upload that to your platform with sufficient rights like you did.