As a fanboy of the Organizer, having used the program seriously since version 3 and upgraded every version thereafter, my answer is that it is the best solution for your dilemma. Over the years, I have tried out a number of other programs but I have never left the Organizer.
There is no reason to gather your images in one folder before cataloging them. The Organizer is a database program and will find and display your images no matter where they are on your computer. It is also not necessary to rename your images beforehand.
However, once you have your images "Organized", you can in fact move and rename your files if you want to clean up your computer. The Organizer has the facility to do this, but as I think you already know, you should only use the Organizer, not File Explorer, to do this, once your files have been cataloged. Also, one easy way to do this would be to backup the catalog in the Organizer and restore the files to a new location/drive/main folder.
The Organizer will also provide some measure of avoiding duplicates. However, depending on what you consider to be a duplicate, the program will not free up your computer from them if that is one of your goals. To do that, you should use one of the many duplicate file finding utilities that are out there.
The program has many features that provide some automation to tagging your images. It will provide automatic "smart" tagging of your files as a first step. While the process is not perfect, it will give you a head-start in finding an image that you want before you go through your pictures to tag them manually. Face recognition is also a great aid in tagging and finding people in your images. If you have a large number of video files, I would also recommend upgrading to Elements 2020, as this version introduced face recognition for video files.
Depending on the number of media files you have, the automatic processing can take many days (even weeks) of 24/7 computer use. But at the end of the road, you will have a program that will allow you to find your photos in seconds.
One final point for now, the Organizer has many other features besides organization. I find that the Instant Fix editor provides a very quick and easy batch editing tool. While I have many photo editing programs on my machine, I am using it more and more to do a quick cleanup of my images. The Slideshow editor also provides a quick and easy way to create a video slideshow.
So, to sum up, what have you got to lose by trying it out? You may like it. And if you run into any issues, there are some knowledgeable folk here to help you out.