Depends. The website MacOS9lives suggests not. That site skews heavily towards DAWs. There are tons of sofware and hardware peripherals that only run under OS9 and are still making music today.
Indeed. One of my siblings is a professional musician who has made a slew of chart hits that were produced with the involvement of Macs that are running sound engineering software and are interfaced to sound engineering hardware that requires OS9.
Catalina is useless for me because I'm quite happy with El Capitan and the older versions of OS X serve me well, regardless of their obsolescence.