Why do I have shoulder pain at rest or at night when I can strain with it during the day?

These painful manifestations are typically ‘inflammatory’ which confirms the reasoning.
On the contrary, ‘mechanical’ painful manifestations would appear in the use of the shoulder (and would be more directly linked to tendon rupture).