Does the transfer of energy take place when you push a huge rock with all your might and fail to move it?

No, the transfer of energy will not take place when we push a huge rock and fail to move it.
No loss of energy will take place because the applied muscular energy will be converted into heat energy which will heat up the body.