Spiritually speaking, why is this funny?

Possibly because nuns are often portrayed as cold, detached women in medieval clothing. We're surprise to see them enjoying themselves as everyone else does!