OK, what you have is one or more of three things, slipped oil bearing, rod knock, or wrist pin knock.
Your motor is/has failed I would be 99% on this, and would be planning for the worst soon.
You can check further with a largeish screwdriver and figure out which piston it is thats going by placing the screwdriver on the valve cover, over where each of the pistons would be and put your ear on the end of it, the loudest knocking spot wins
Id also be willing as another check is I bet if you keep it in park, and just slightly bring up the idle you'd find the sweet spot with the rpm's that you can make the knock go away or become very faint.
If it were a rocker arm, it wouldnt be a knock sound, more a loud tick, and it would be all the time no matter if in gear or park, or the rpms for it would have to be a lifter for it to go away if anything other then a idle, and Im not sure or not if you have those in that motor, and again it would be a tick, not a knock for it opens the valve on the top half portion of the motor, that is easy to tell just by listening and would be REALLY loud using the screwdriver trick. If its near the top half of the motor, rocker, but bottom half, worse, and there really is nothing more it can be if its the bottom half to make a knocking sound. But since it goes away under stress my money is on lower half something failed and she about to go boom, stay as far away from high rpm's as you can, and baby the hell out of it, no unneccessary stress till you have the means to fix or get something else, and there is NOTHING on the market in a can, bottle, air, that will fix the problem, it must be taken apart.