Phil Collins has revealed he nearly died in 2024 after his alcohol addiction left him in intensive care, with his family "coming to say goodbye".