I’ll confess! I’ll confess!! Whatever you need me to confess to, I’ll do it! Just stop the torture!
That, in my opinion, is classic “lower end noise”. The bass profundo culminating in a mid-range clatter? Big end rod knock. I think the reason it’s “going away” when the RPM gets higher is that you had a relatively healthy engine until starvation ate the bearing, so once you get the oil pumping hard enough with enough RPM, it manages to fill the over-sized void where bearing material SHOULD be, and begins to operate “more normally”.
I would not start the engine again.
I would drop the oil pan, pull rod caps (the one furthest from the oil feed is the most likely victim), and assess the damage. IF you’re lucky, you could get away with new bearings (in my opinion, from behind the keyboard, that is unlikely; you will need a crank, and/or rod(s)). But there’s only one way to be sure, and that is visual inspection and/or quantitative measurements.