The monthly/annual subscription fees can be hugely significant, as they are for WoW from Blizzard, but unless you get a critical mass of players to make the game interesting to participate in, it's likely to die quickly. So it can be profitable or not, depending on its retail and subscription success.