It's also why so many really good TV shows and series get canceled.
The money is not being invested to create an art project.
It's being invested in hopes of a gigantic return, and the instant it seems like there will not be a gigantic return the money goes away.
That's why you do not often see several hundred million dollar productions of original material unless it's a passion project for a specific director or studio.
That's why we've had, what is it, 10 Spider-Man movies in the last 25 years?
I get you can't just throw money away but I feel like there should at the very least be some sort of clause and a contract that says that if your show gets canceled then you will be provided the timing and funding to either finish up the season that you are in and provide a finale or two at the very least provide a finale.