Sleepy Joe is a nickname describing Joe Biden, the 46th president of the United States, coined and used by those who opposed his presidency, which became an Internet meme. From Wikipedia
Rogan humorously suggests Biden's happiness during a meeting with Trump indicates secret support for the President-elect.
