Sounds like a charging system problem
Sounds like a charging system problem. The alternator/battey light should NEVER be on when the car is running. Your battery is going dead because it is not being charged. Your car is running on low voltage, with all the computers contain within, strange things WILL happen. This will include the possibility of the radator fan not running when needed.
There are probably multiple problems but likely the battery is not one of them.