Seeking iPhoto replacement

I have been using Apple's iPhoto since it first came out well over a decade ago. I am approaching 65,000 photos in my iPhoto library.

For years, I have organized photos by subject matter, most often labelling Events with cursory, but thorough, descriptive titles of what I photographed in the Event. iPhoto allowed me to also deposit thorough narrative descriptions (like captions) in the metadata of both overall Events and in individual photos. This proved valuable countless times in the last several years, as I am able to type in detailed descriptions (including names of people, specifics of happenings, etc.) in prose.

I capture family events, work projects, volunteer work bees, public events, scenic vistas, trips, wildlife and more. iPhoto turned out to be very useful for work and play, and it made being a photo mega-packrat a passionate "other life" of mine.

Now Apple has killed iPhoto, replacing it with Photos. Google is also entering the photo market, with its own Photos app. I've tried using Apple's Photos, and it comes across as iPhoto Lite; very dissatisfying. No more Events titles to use for referencing bunches of photos. Accessing captions is much more awkward and not as useful as in iPhoto. I am afraid that converting my iPhoto library over to Photos will loose valuable information, and I don't know how you would do it unless it converts everything all-at-once.

I have been snapping digital photos since November of 2001. All of my digital photos are in my iPhoto library, and nearly every Event is given a brief narrative Event name for reference.

This iPhoto library is not stored on any cloud service. The library is on a portable hard drive so it can go to reunions, meetings, and other business events where cellular and internet connections are not available. So Cloud-based services like Google's Photos are out of the question. (And if Apple's newer Photos, is like iPhoto Lite, Google's Photos comes across as iPhoto Lite Lite.)

So, I have to ask: is there a modern digital photo library software solution on the Mac that carries on where Apple's iPhoto left off, without costing an arm and a leg? I currently have access to Adobe Lightroom CC, but I am reluctant to make a long-term commitment to Adobe CC apps because my future subscription is currently in (partial) doubt. If necessary, I will commit to Lightroom, but I prefer not to since I share this portable hard drive with my parents, so they can share the same iPhoto library on their own MacBook Pro.