Is a school supposed to offer the financial aid to cover a gap between COA and EFC?

Supposed to? No. Some schools state they will meet need which will mostly bridge that gap, but most schools don’t have the deep pockets to do that.

Pick a school at which you can get merit aid or can afford outright. The ultimate fall back is start at a Community College and save during that time to afford the transfer to a four year.