Like a firework, the CSL was once loud and impossible to ignore but now in 2023 it has all but disappeared from the football world's collective consciousness.