I'd love if it just created a new table, moved the data over, and dropped the original table while maintaining the foreign key relationships. That would be perfect.

If you have foreign key relationships referencing the table, you can't drop the table. You can't remove the foreign key relationships without modifying the related table. But you can't modify that related table, you can only drop it. But you can't drop that table because of other foreign key relationships...