Why does Disksomnia only work with Final Cut Express and Final Cut Pro?

Because that's where sleepy disks are most annoying. If you want to stop disks from sleeping, regardless of the current application, you may want to take a look at No Spin from Mosaic interactive.