Depending on where you live, some academic libraries give membership (possibly for a fee) to people living within a certain distance, as a kind of local outreach/PR gesture. May be worth a look at a few universities near you to see if that's the case.
One extreme example is that anyone who lives in Texas can apply for access to any library in the "TexShare" system of public libraries, which includes the state university libraries. You first get a library card from your local public library, and then apply through the TexShare program for access to the university library you want: https://www.tsl.texas.gov/texshare/card
Generally none of these programs allow you to use the interlibrary loan service though, only resources the library itself has.
I can highly recommend "The Oxford Guide to Library Research", which hammers down this point and is an eminently practical book.
I found it ten years after being a student. I think every student should read it at the beginning of their studies.
The myth that everything is out there on the web is really belied by a few hours spent in a subject-oriented academic library.