The SP Tweet extension is broken in Joomla 4.0.4. The problem is in components/com_sppagebuilder/helpers/tweet/helper.php. Line 32 is:
$tweets = json_decode(JFile::read( $cache_file ) );
but JFile::read is now depreciated and should be rewritten as:
$tweets = json_decode(file_get_contents( $cache_file ) );
Works after that change, hope this helps.