Add Link to Users List (Backend) to open each users front-end profile

The following will add a “View author profile” link to the row actions (i.e., the links that appear when you hover over the username):

add_filter ('user_row_actions', 'add_view_author_page', 10, 2) ;

function
add_view_author_page ($actions, $user)
{
    $href = esc_attr (get_author_posts_url ($user->ID)) ;
    $actions['add_view_author_page'] = "<a href="https://wordpress.stackexchange.com/questions/259665/$href">View author page</a>" ;

    return ($actions) ;
}

Edit:

Or if you prefer to have the link in column of the table, you could do:

add_filter ('manage_users_columns', 'users_columns') ;
add_filter ('manage_users_custom_column', 'users_custom_column', 10, 3) ;

function
users_columns ($cols)
{
    $cols['author_page'] = 'Author page' ;

    return ($cols) ;
}

function
users_custom_column ($default, $column_name, $user_id)
{
    if ('author_page' == $column_name) {
        $href = esc_attr (get_author_posts_url ($user_id)) ;
        $default .= "<a href="https://wordpress.stackexchange.com/questions/259665/$href">View</a>" ;
        }

    return ($default) ;
}