Yeah, it's basically tilting.
While the gyro is on you can assist horizontal camera control with the right stick and reset the position with the Y button. I'm not the biggest fan but many people like it once they get used to it.
The gyro is definitely a faster way to aim than the sticks in splatoon, but as someone who squirms a lot as I play I still found it basically unusable. I felt like I had to maintain a fairly stiff position to use it effectively.