Here's the working file:
The in-plane rotation in shells is not like the out-of-plane rotation.
It does not represent the rigid body rotation, but a deformational rotation also called drilling rotation. It is something related to the Cosserat continuum theory.
If you want to fix the
in-plane RIGID BODY rotation of a shell you need to:
Release the deformational rotation Ry:

- fix_inplane_rot_1.png (57.4 KiB) Viewed 6037 times
Add an interaction to impose the same displacement in Z. Since the rigid body rotation about Y consists in a skew-symmetric displacement in Z (+ on the right, - on the left), the equal DOF in Z will constrain the rigid body rotation:

- fix_inplane_rot_2.png (65.68 KiB) Viewed 6037 times
This is what you get:

- fix_inplane_rot_1.png (57.4 KiB) Viewed 6037 times