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.