We have been in the secret porthole rooms many times. While forward can be prone to motion, we have never had a problem. It would be more pronounced higher in the ship (the most I ever felt was during a massage on deck 9 forward), but the ship has excellent stabilizers so you should be fine. The SPRs are in a very convenient area...Deck 5 is THE BEST!
Barb