even with full archival nodes, if you don’t have txindex on you won’t be able to easily extract the op_return from a txid.
Discussion
I'm something of an archivist myself.
One of the things keeping node runners interested and leveling up their skills is running services adjacent to the node, like block explorers and lightning. Without indexing, pretty much anything interesting you want to do with a node is off the table.
Core devs are at the "just disable txindex and everything will be fine" stage of collapse.