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.