It absolutely is self-executing. From the text of the 14th Amendment:

But Congress may by a vote of two-thirds of each House, remove such disability.

So it follows that Trump would be disqualified absent any action from Congress, since they can only vote to lift such a restriction, not on whether or not to impose it.