My Mac lost power and now my Plex server won't run

Yes a complete uninstall is warranted when you’ve removed your db already.
This will not touch your video, music, and media, just the PMS software and config files.

How to Uninstall PMS

Because you’re on a Mac and a Plex Pass, you can try the fancy new PMS Transcoder Preview that’s optimized for Apple Silicon. It’s ridiculously fast and stable from my testing on a Studio.