activate_header hook is defined in wp-activate.php file which includes theme’s header.php but not the functions.php file. So it will throw fatal errors if any function or functions called on fire of this hook which are defined in theme’s functions.php. Also it’ll not work if you hook any function in functions.php. And this wp-activate.php page is only being called when WordPress multi site network is activate.