Hello Dear,
Its not a database issue because site admin is working.
so please first check SSL certificate setting may be you didn’t apply for front just activated for admin. when you will apply for frontend then you can use https for front. it will work.
by the way its not work then use those lines in wp_config.php
define(‘WP_HOME’,’https://example.com’);
define(‘WP_SITEURL’,’https://example.com’);
Definitely your site will work !
Thanks
SURENDER SINGH