Since no one came here to give a good answer, then we could just imagine the Keras guy banged his head hard just before coming up with this counter intuitive naming convention, and whenever we want to remember the correct name, just exchange them:

• lots of zeros? "categorical"
• no zeros? "sparse categorical" 🤪