It is possible that that could happen, but it is also important to remember that if an engine won't benefit from 0w40, then you won't see any difference, other than slightly decreased MPG.
IOW, don't just throw 0w40 in your Honda thinking it will prevent issues, or that it will protect the engine better. If you ran your engine at 6500rpm all day long in 90+ temps, then the 40w would help, but how often do you do that?
In the case of the 6.2L, the engine bearings are wearing in such a way and under such conditions that the 40w will protect those bearings better under extreme stress. In simplified terms, GM will check the alignment of the crank, and if it doesn't meet spec, you will get a new short block. If it does meet spec, they will recommend the 0w40.