Poison drummer Rikki Rockett recorded messages for his kids as cancer threatened to take his tongue