The president called the wrestling icon a ‘great friend’ and hailed his ‘massive’ cultural impact over the years