There's a very big element to erotic love that is related to the "forbidden." I don't think that is what God has in mind.
One might even go so far as to say that the desire for erotic love cuts to the very core of our fallenness.
There are drugs that produce the same or very similar neuro-chemical effect as erotica and erotic sex. The hunger that such drugs elicit is powerful to the point of being addictive (just ask Hunter Biden). I have known men and women who are overwhelmed by the need to feed that hunger.
This seems to be one of the hallmarks of human fallenness (that is, the obsessive need to satisfy a hunger that is opposed to obedience to God).
At 77 Piper has fallen to the vanity of trying to be of worth by originality and offering unique thought. Twenty years ago he would have never spoken like this .