For specialized software, tailored to specific fields, with only the interaction elements for particular jobs the iPad can be a much better fit than a laptop. Those jobs however aren't generic enough that off shelf software make a ton of sense.
I’m not saying Office for iPad is pointless (I use it regularly, so quite the opposite!), but I do think it’s foolish to think an organisation the size of Microsoft’s doesn’t necessarily do things for obvious reasons. Individual incentives do not always lend themselves to data driven objectives.
Loss-making strategies can ultimately be profitable in a broader sense (if it increases the stickiness of the product on it's primary platforms, keeping away competitors, a strategic moat).
I don't think there's any evidence either way to be able to make any assumptions about the level of interest of the product, and whether or not that justifies it's existence.
The iPad Pros are credited with stopping the slide of iPad revenues - along with all of the accessories.