Pagination broken by naming conflict between CPT and Page

You can add a rewrite rule to override the post type rules and force it to load your page.

function wpd_fix_insights_pagination(){
    add_rewrite_rule(
        'insights/page/([0-9]+)/?$',
        'index.php?pagename=insights&paged=$matches[1]',
        'top'
    );
}
add_action( 'init', 'wpd_fix_insights_pagination' );

Visit your Settings > Permalinks admin page after adding this code to flush rewrite rules.