But, why will it happen anyway?
Because all limits are successfully bypassed, one-by-one. And UTXO set has no consensus-enforced limit. Which means, that if it is possible to abuse pruned nodes, and to make them store as much data as non-pruned ones need today, then someone will do that.
Do you mean that it is simply possible to happen given enough incentive?
This is one thing. Another is history:
1. Block size limit: set to 1 MB. Reached.
2. Witness size limit: set to 4 MB. Reached.
3. Sigops limit: set to 20,000 (and for witness, increased to 80,000). Reached.
In progress:
1. Time limit: around 0x7fffffff in 2038, and 0xffffffff in 2106. The first one would cause some issues, because nodes cast types between signed and unsigned integers, between 32 and 64 bits. So, even in 2038, there would be some problems, even if those values could work well until 2106. You can always set your system clock to 2040, and see if your regtest node is affected or not.
2. UTXO limit: unlimited, enforced only by the physical specification of most nodes. Will be abused, sooner or later. And then, some limit will be introduced, or it will be abused further, if community will be too lazy to "fix" it.
There are more to-be-reached limits. But we are not there yet, to discuss them properly, because each "fix" and each consensus change, can dramatically change the situation, and stop some attacks, or make other attacks easier. It just depends, if something will be changed, and it depends on how exactly it will be changed. Devil is in the details, and I can guess, what will happen, but I cannot be 100% sure about that. But of course, by writing some code, and testing some scenarios, you can figure it out.
So you're arguing for softfork.
Well, this is the way to stop the attack, because it is too late to stop it in other ways. But you should think about it more widely: I would rather see a soft-fork, which would allow regular users to join their transactions, than a soft-fork, which would explicitly block Ordinals. Because if you "censor" anything, it will have some bright and dark sides. So, it is more clever to do, what the network should do: to prefer payments over Ordinals. And "making regular payments cheaper" is not the same thing as "blocking Ordinals explicitly as a protocol rule".
However, if nothing will be done, then all you can do, is to discourage people to use Ordinals. And if you want to do so, then what you can do with officially released software? Not that much beyond pruning, I guess.
is there discussion about implementing a softfork for this very purpose?
There was a discussion, when the attack started (but not about soft-fork, because then, it was not that serious as today). And there were no decisions to block anything, which means, that status quo is preserved. For many different reasons. Also, because if you want to change something, you have to propose it, and reach consensus. And for simple fixes, like "blocking relay for Ordinals", they were rejected, and not merged into Bitcoin Core, which means, that this proposal was unsuccessful.
And today, there are consequences. Some of them are good, and some of them are bad. The good thing is that some attackers focused on Ordinals, which means, that they can be "censored" in the same simple way, as long time ago, when the attack started. And it is a good thing to keep it like that, to then throw everything away at once, using the same new rules. But of course, there are bad things, like "UTXO flood", which are going to happen in the future, which means, the "fix" will have to address both issues at once: spamming with data, and spamming with UTXOs, at the same time (or it will be insufficient, and will not stop the attack).
I mean serious consideration, not just beating the air.
Note that "status quo" is the default. Which means, that everything works without any changes, unless you successfully propose something, write a code, write some tests, get it accepted, and then get it merged. The path to change consensus rules is much harder, than the path to fix typos in translations.