Once I complete the four modules for the managing professional designation, do I need to pass an additional exam to get the ITIL 4 Managing Professional designation?

No, once you pass all four modules you will automatically receive the ITIL 4 Managing Professional designation.