Is CI4 still a small footprint framework ?

Yes and No ..

In dev mode there are a lot of shits added by composer for phpunit testing and etc..
In production mode composer adds just 4 additional packages and with them the size of the CI app become about 5MB.. (total ~800 files)

I think its really small footprint, if you try production mode of Laravel Symfony etc.. you will see the difference .

Best VPS Hosting : Digital Ocean