If the preset was created with just the option Transform > Upright Mode checked (and no other Transform option checked), then when the preset is applied to multiple photos, the auto mode (Auto, Level, Vertical, Full) will be recomputed for each photo.
But if you create a preset with Transform > Upright Transforms also checked, then the preset will apply the specific transforms that were computed for the photo from which you made the preset (probably not what you want).
If you want the set of bracketed photos to all get the same exact transform as computed for the first photo in the set:
1. Select the photos and go to Develop.
2. In the Transform panel, select one of the auto modes.
3. Do Sync Settings and check the options Transform > Upright Mode and Transform > Upright Transforms.
(And yes, someone will chime in and say, "Use Auto Sync". But Auto Sync is dangerous and often ends in tears.)