Well, couple things here:
a) raising ticket prices isn't the end of the world. If you consistently put a product on the field that's worth watching, like many of the big market teams do, fans will pay a higher price for tickets. Willfully. That's pretty universally true.
b) Tampa (and Florida in general, quite frankly), in your example, struggles in two aspects. One, they rarely have any actual "star" players. They have a roster full of very good players, but nobody that the fanbase can get behind, because they won't be there long enough to get invested in. Star players is what drive people to come to the stadium.
Second, and most importantly, Tampa is basically a really shitty shorts town across the board. They've never really supported baseball at all, the stadium is in St. Pete, which is effectively an old person's village, and frankly they never support the Bucs that much either before Brady got there.
In most situations, teams attendance will rise and fall with the product on the field. See places like Kansas City, Cleveland, Houston, etc. Houston's attendance was putrid in their "rebuilding" years. That's a pretty big market with lots of $ to spend. KC stadium was full during the brief period they were WS contenders (and winners).
c) It's a major fallacy to suggest the team can't operate in the short term at a loss. They certainly can. 10 teams had negative operating income in 2022 alone. Some of them with very large amounts of negative operating income. It's not a requirement of the business that they be profitable every year. That's an Angelos choice.
d) Raising ticket prices isn't the only way to generate higher revenue. In fact, it's not even the best way. The best way would be either to put a product out on the field that MASN will actually pay you more $ to broadcast for, or create/spin-off into your own RSN.
The Yankees did almost $400M in revenue more than the Orioles last year. Gate receipts were about $250M of that, which is substantial. Orioles will never get to the gate receipt level of the Yankees due to pricing and just lack of brand name, but they can bridge the gap.
The other $150M is the difference between what the YES network pays to broadcast Yankee games, and what MASN pays to broadcast Orioles games.
Because of the Orioles declining controlling interest in MASN, and the fact they're required to re-negotiate every five years with the Nationals for broadcast rights, they really don't have a good "deal" compared to how other markets have structured their RSN agreements.
10+ years (which again we have already seen that 10 years is not enough sustained success to turn a small market into a medium market) is not short term. If you told those businesses there is no example that suggests you will not be losing 50m per year for the next decade+ and there is no historical precedent that suggests it would stop, then you are not going to get many to take that bet. There is a difference between "we are going to lose money for a year or two" and "we are going to lose money for the next decade with no way of fixing it but at least the team will be good".
I get the problems with Tampa but the problem is you typically do not have many good examples of small market teams having stars because they are frankly expensive. Ohtani may very well get a larger salary than the entire As roster. If they signed him they would have a star but there is no way they generate enough revenue to justify it.
It is again a fallacy that a successful product will just automatically be worth more to broadcast. The Mets are terrible were terrible and will continue to be terrible but will be worth more for broadcasting than the Os because the market is bigger. That is the advantage of a big market. You are more valuable if you win more but not enough to actually overcome market size. Case in point in the NFL the Cowboys vs Giants always draws big even when both teams are awful.
Now I will not pretend to know the intricacies of the MASN deal compared to other deals but there is no way you are going to get the national brand recognition that the Yankees have as well as simply the local fanbase that is again significantly larger due to being a larger market.