style.css of my custom theme is not being applied at all

As Michael in the comments pointed out, it was caused by a typo. I had just misspelled the word ‘scripts’ in wp_enque_scripts. Kudos to Michael!