The popular yet troubled $75 million Broadway musical fell short of the break-even point for weeks, sources say