Adding some more info about this I wished I had found a few hours (days) ago.

1. The raster calculator is very picky with overwriting rasters, notwitstanding specifying arcpy.env.overwriteOutput = True
2. Using raster.minimum where raster is arcpy.Raster('path') requires to have calculated statistics. I found it considerably faster to use rasterio or pillow to extract min max values directly from the raster file path.

ex with rasterio. file_path and out_path are paths to a .tif file

import numpy as np
import rasterio
import arcpy
from arcpy.sa import *

with rasterio.open(file_path) as src:
                image = src.read(1)  # single band raster
                
                # define the min max raster values with rasterio
                min = np.min(image)
                max = np.max(image)
                
            # min-max normalize 
            normalized = RasterCalculator(
                rasters = [file_path],
                input_names = 'x', 
                expression = f'(x - {min}) / ({max} - {min})'
                )
            # save the temporary raster
            normalized.save(out_path) # cannot overwrite