Of course it's different. The CD can hold 500MB+ of data, and load it into RAM when required. A HuCard/cart can only hold a few megs in total. IIRC SFII on PCE is 20 megabits, or 2 1/2MB!
The only appreciable difference there is cost. 20 megabits isn't the max allowable rom size; with the right mapper, a huey could be made to hold just as much as any cd game made, none of which are even close to 500 megabytes in game size (most disc space is filled with adpcm samples and redbook).
Are you sure about that?
Even if that is true, the price of such a HuCard would be brutal. Approaching higher end AES cart prices back in the day. That's to say nothing of the reduced performance from the phenomenal amount of bank switching that would be required. CDs were far cheaper and more simple to deal with.
Comrade, I know what you are thinking... I, too, was confused about the "bottleneck" that is created for CD-ROM games based on the fact that only ____________ of data (depends on the system card) can be loaded and therefore available at any given moment.
If you want LOTS OF ANIMATION in large sprites... you can quickly run out of room.
Therefore, once it was evident that the install base of CD-ROM hardware was healthy, developers/publishers *still* had a decision to make: did the technical requirements/challenges of the game lend itself to HuCARD or CD-ROM.
CD-ROM was not automatically the best fit for every project.