Is this DIY pull up bar and dips station structurally sound and is it a good solution?
This is not as structurally sound as it could/should be. With such large dimensions between corners, adding some diagonal bracing will improve the strength by a substantial margin. As I typed this, I see Ed Beal has added the equivalent in a comment.

Triangles are your friends.