This is a question worth asking. As others have pointed out there sort of seems to be clear that the rules are the rules and business rules trump all other rules. The Rules of Acquisition tend to be the Ferengi Alliance's highest law. It's both a religious law and a practical one and I think therein is where the problem lies. You can't make profit outside of the constrains of normal ethics because whatever makes profit is what is ethical to do.

This is why so many contradictory Rules exist in this system. War is good for business and peace is good for business, and neither of these are statements on what is "bad" for business. There's nothing here that says not to do anything and I think in this way Ferengi ethics largely comes down to there's no precept that says I shouldn't do this and I was able to exchange doing it for profit so ultimately it serves a higher purpose.

And since it seems like there is a fair amount of legalize extortion that happens in Ferengi while it might be technically illegal to do slavery, it might be more profitable to do it and therefore on the whole you can come out with an ethical conclusion that is "good" especially if you're some mid-level Ferengi in charge of making sure that slavery doesn't happen and you're able to take a little bit of a kickback.

I mean let's be clear for most of Ferengi history women were not allowed to own property of any kind - including clothing and some of their business endeavors include poaching endangered animals and literally being slave traders. I mean - I don't think there's any indication that Ferengi society was anything more than hyper-capitalist dystopia as a juxtaposition of the Federation socialist utopia. That Rom and Quark are goofy and lovable I think speaks more to how bad every other Ferengi is operating outside of a Federation station.

From the Federation's perspective the Ferengi are harmless and in this way they may be ethical enough to not warrant confrontation, but at the same time - the Federation does seem to stop them when they're doing something like slave trading so I think we can imagine that for some people in the sphere of Ferengi influence they're not so ethical.

that we shouldn’t take dates on the show literally other than as an indication of the general order in which things happened

I absolutely am fine with this take now, especially. Ultimately, what we are talking about is the narrative importance of the events. If we want to have episodes where the characters go to "today" today must continue to exist within the narrative. If the narrative says that the world was noticeably different in 1996 - move it to 2036. If we're still going strong move it to 2056.

These changes don't make as much difference in the narrative that was being told to begin with.

I don't think that changes anything that was previous established. Picard established that Soong did illegal genetic experiments, but it does not stipulate that his experiments were illegal because of a prior genetic research ban. Soong later recovers the 1996 Khan Project file.

My take is that Romulan time agents went back in time to hide the Khan file. They perhaps moved Soong away from that avenue of research not knowing how the Confederation would play into it. In any case it didn't work because Picard did his own time shenanigans pushing Soong to take more drastic measures.

In less than a year the Khan project has found a new home in Canada with new research partners. The Noonien-Singh Institute has Adam Soong's fingerprints on it somewhere, but it's unclear where. In any case whether there is a connection or not, Soong discovers the Khan project from 1996 in 2023. In SNW the Khan project has only just begun a year later and already has found its Khan.

Pursuant to this and maintaining consistency with the CO/XO dynamic on many Starships it's totally reasonable to have a small vessel commanded by a Lt. Cdr. who we call the Captain, with a Lieutenant as the first officer.

Tuvok is such an example as he is almost always referred to as Lieutenant and later he's promoted to Lt. Cdr properly, but he wore Lt. Cdr. rank insignia for like maybe the first season without anyone really correcting it.

It's true that Tilly was not 'promoted' to any rank and kept her rank simply being assigned a position, however, I think it's weird for her to be the XO except that she was part of the principle cast and they needed to give her a reason to be part of the overarching narrative for each season.

but it feels big to actually use the word?

I felt the same way. This reminded me of Discovery's Admiral Vance openly admitting to ending capitalism being a goal of the Federation.

I don't think it's the best season of Picard. I think, in fact, it was the worst if only because it did not fit narratively within the rest of the Picard series. It was essentially a soft reboot of the series letting most of the primary cast disappear and replacing them with the nostalgic cast for the finale.

I agree though, Lower Decks and Prodigy did it first and did it better than Picard because they stayed true to the ideals of Starfleet and the Federation and made this a main point of the series. Something that I think both animated shows do extremely well. Contrast this with Picard's Starfleet and Federation - they are in this position because they are spies, torturers, and liars who engage in grave robbery and allow themselves to be constantly defeated at their own hand by hubris only to be saved not by Federation and Starfleet ideals, but by the opposite (as presented.)

I also think that this same phenomenon happens in TOS as well although to a much less noticable degree. While that crew was always depicted as a little more willing to bend the rules, the movies had them breaking all the rules with a smirk and I think part of that was just the desire to hammer into the same nostalgia that Picard 3 tries to do. Unfortunately, Picard 3 doesn't give us original characters or original concepts and so it needs to be maintained through relationships to existing characters.

I think part of the original intent was to have Starfleet be that Merchant Marine fleet and serve similar roles, however that was largely left on the cutting room floor. As a result I think the best way to understand a Merchant Marine ship like perhaps the SS Puget Sound (a Federation colony ship) could indeed be a Starfleet vessel (made by Starfleet), commissioned by the Federation, but commanded by a crew which hold Merchant Marine ranks and not Starfleet ranks. A Federation Colony Ship.

This would help explain the massive function of a 22nd or 23rd century Starfleet being operated entirely by a military organization. It's not, many aspects of the fleet are controlled by the Merchant Marine service. A Federation Freighter likewise would be any freighter commissioned by the Federation and therefore likely to be crewed by the MMs.

I think narratively it's just a much more enjoyable to not have Odo shift shape onscreen, especially as it gives him the ability to overpower a lot of people. In the early episodes this needed to be shown so we could understand Odo's character, but by the fourth season (both when he was a solid and not) we knew enough about the Changelings that we didn't need to show this as frequently and had to figure out more creative ways to to get around Odo.

Narratively rank is very important especially when you are trying to demonstrate a paramilitary organization in the confines of a television series. I think there are probably often arguments about this. Why is Ezri written as a counselor and an Ensign instead of a science officer of a higher rank?

I do think there is real world relevance sometimes. We see Worf and Geordi get promotions and become a larger part of the series with more screen time and character development. This works narratively to distinguish the change. An "on screen" promotion indicates some sort of character growth. We see this happen with Sisko likely because the only reason to distinguish him at first was because he was written to have a fairly minor (in universe) role which was greatly expanded.

In recent years I think rank has been downplayed as there are so many inconsistencies and patterns and anti-patterns throughout the series. It's important that you're able to tell a story where if someone is supposed to be in charge they have the appropriate rank for this. This is one of the reasons Discovery effectively promoted Tilly rapidly (all the way to being the XO for a little bit) because she was a pivotal part of the cast and needed screen time. In fact Discovery doesn't "ignore" rank it rather ignores rank conventions by having a mutineer on the bridge as a 'specialist' and a command staff that almost just takes turns at the wheel.

In Lower Decks we can assume narratively no one is going to get promoted permanently or demoted permanently because the show depends on that dynamic. If we look to Strange New Worlds we see rank downplayed to a large degree because everyone's rank is so close together. This is important to get Spock of a low enough rank so that he can be promoted to commander later. (Frustratingly there are still inconsistencies here. There seems to be confusion between Lt. and Lt. Jg. and Nurse Chapel's rank, which may be provisional because she may be a civilian contractor who has a temporary commission and then later joins with a regular commission of a lower rank - or her rank is just not important - is also out of continuity.) But importantly for SNW - narratively it makes sense to have these people of these ranks in these positions so it just works.

In a more realistic depiction people would be moving through ships much more quickly. There would be fewer officers and they would move through the ranks regularly and not stay in one position for 7 years. Likewise mostly Enlisted people would be spending a few years at most and moving onto other careers in civilian life as most people don't want to be in the military forever and if they do they become officers. Miles O'Brien (despite the insignia being weird) is probably most accurately depicted. He served on many posts, he left posts for some period of time and then returned to them in new capacities, he moved between posts. He joined in 2345 and by 2375 he was probably ready for retirement or in the case of a utopian future, moving back to Earth to teach at Starfleet until he is absolutely ancient because he's got nothing better to do and he loves his job.

Prodigy is canon insofar as everything is canon when it happens on screen. I like to think of the canon containing all Star Trek works right down to your fan fiction novel or your "head canon" with some things being more canonical than others and with those things which are seen on screen either as a film or TV episode are the most canonical of the canon. Prodigy still fits that bill. I doubt that there will be anything as canonical that would "undo" what Prodigy did. But if that happened we would just incorporate the conflict into the canon like we always do.