There only needs to be the smallest amount of oil between the bearing and the journal for an oil wedge to happen. So as long as the wedge is higher than the roughness of the bearing and journal no wear should happen. Having said that I paid $1800 to have oil supposed to the camshaft on my Lycoming IO360. The standard arrangement is that splashing from oil in the engine lubricates the lifter/camshaft area. My engine had a valve lift around have the design lift from wear. The oil was wearing off the camshaft after sitting for extended periods of time. Hence no wedge on startup. Lycoming suggests that you use a "magnetic" oil to solve this problem. So I really wasted my money, I lost confidence in my judgement lol.
My father used to say that if his car ran out of oil he would put water in his sump to get him home. I once thought that it was a great idea, after all both form a wedge in the journal/bearing area. How once the fluid shearing heat had raised the temperature of the water steam would have formed. With steam's lower viscosity a very weak wedge would have formed. Steam also has much lower heat transfer coefficient than water so it would only have worked for a very short distance. OK if very close to home, maybe easier to push the car, ?