Regarding Lightroom, Lightroom doesn't actually do anything with your RAW or JPEG photos, unless you want it to. Lightroom actually creates a "catalog" of data about your photos. Any importing or changes you make in Lightroom is stored inside the Lightroom catalog itself. Your actual RAW and JPEG photos are still in the same places, they're never moved, and they're not touched by Lightroom. So you are not importing 22,000 actual photos into Lightroom...you're only importing data and previews of 22,000 photos.
With over 22,000 photos in your library, Lightroom is actually the perfect program for organizing your photos. Lightroom was made specifically for photographers to help with their / our workflow.
I'm sure the same can probably be said about how Aperture works.
There are lots of great introductory books and tutorials about Lightroom. I'm sure you can find some on
YouTube. Actually, Adobe has several excellent links to different places where you can learn Lightroom:
link.
Don't be discouraged. All software take a little time and effort to get used to. But once you get used to it, you'll see that Lightroom is really made specifically for photography and that it's flexible enough for
your digital photography workflow.
Hope that helps.