How to fix too many redirects when enabling SSL for site?

Using a redirect from your web server isn’t the best solution in my opinion.

Instead, why not fix directly the content of your database? (using https:// instead of http:// everywhere?

You could do that using a WordPress plugin such as WP Migrate DB or the command line tool WP-CLI.

Using the plugin option (WP Migrate DB), in the administration go to Tools > Migrate DB.

Using the command line tool (WP-CLI), use the following command line: wp search-replace http://oldurl.com https://oldurl.com

After applying one of these two solutions, you should have a correct site that uses https urls instead of http.