The main concerns about social media CEOs discussed in the video include the issues of child exploitation, child abuse, and overall safety on their platforms. There is also a focus on the illegal drug sales and counterfeit pills being marketed on these platforms, leading to a spike in teen drug poisoning. The question is whether these companies are doing enough to address these issues and whether Congress needs to mandate action to make the platforms safer.